Oracle & DB2 DBA Technical Specialist

Key Accountabilities / Activities:

Reporting to a team leader in the Database Administration and Engineering department, this is a team member who is providing level 2 database support (Oracle & DB2 UDB). The role is responsible for ensuring the effective operations support, production build-out and continuous improvement of database support and services.

Major Activities:

• Support production environments, configuration, testing, and performance tuning of all Oracle and/or DB2 database environments.
  • Verify the database support requests and execute them in timely manner as the business SLA’s.
  • Coordinate and oversee ongoing maintenance and upgrades for all Oracle with internal teams and external service providers
  • Manage the production, deployment & maintenance of a clustered Oracle and DB2 database. Provide expertise around optimizing performance and ensuring high-availability.
  • Provide consulting services to application teams and posses good understanding of DBMS standards and system infrastructure.
  • Provide rigorous testing for new Oracle /DB2 server releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
• Managing problem/project tickets queue and maintaining communication with business team members.
  • Consult with problem/project ticket owners in resolving issues and executing scripts as per the requirements.
  • Continuously monitor the request queue and prioritize tickets in the queue as per the guidelines from the management.
  • Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database system environment:
  • Develop and improve standards for database administration and monitoring tools
  • Accountable for adhering to problem management process for DBMS related incidents consistent with processes to meet service expectations of regional customers.
  • Provide mentorship to developers and analysts in all aspects of database management, automation, troubleshooting, and problem resolution.
  • Accountable for problem determination, troubleshooting and resolution of database/data warehouse - driven application problems through use of system diagnostic utilities and industry recognized best practices.
  • Participates in the improvement of support processes, subject matter expertise, and technical capabilities with the Database Services and Command Center teams to continuously improve service delivery and efficiencies.
• Participate as a team member in evaluating system resource utilization and storage usage/capacity, and makes recommendations to increase application performance to meet business and financial requirements.

Requirements:

Minimum 5 years experience in administering, testing, and support of midrange and large-scale Oracle and/or DB2 DBMS environment. Proven experience in supporting VLDB or data warehousing environments

Proven expert knowledge of:

• Oracle & DB2 Administration
• Preferable Oracle Certified DBA
• Detailed knowledge of general Unix, Windows and Network utilities
• Automated cross platform work/job schedulers
• Ethernet networking
• TCP/IP network Protocol and functions/utilities (e.g. ping/traceroute)
• DNS/DHCP Knowledge
• Windows NT/2000 Server
• MS Office (97 & 2000) and Internet Explorer
• MS Outlook
• EMC SAN technology

Working experience and familiarity with the following technologies:

• Support, administer and maintain Oracle 8i,9i & 10g environments running on Unix platforms.
• Support, administer and maintain DB2 environments running on WinNT/2000/Unix platforms.
• Oracle Enterprise Manager Diagnostic Pack, Tuning Pack
• Veritas NetBackup For Oracle
• Business Intelligence Tools
• Oracle Enterprise Edition Option Packs (OLAP, Data Mining)
• Windows NT & 2000
• Sun Solaris 2.6, 2.8, & 2.9
• Database Management Utilities
• High Availability Solutions
• Strong familiarity with Local Area and Wide Area network topology
• FTP, TFTP, Traceroute, Ping

Nice to have:

• DBArtisan
• Oracle Real Application Servers
• Sybase 12.x
• MS SqlServer
• Veritas NetBackup For Oracle
• IBM AIX
• Business Intelligence Tools
• Enterprise Modeling Tools
• ERWIN
• Veritas Cluster Server Manager
• Geo-clustering
• Middleware
• Informatica
• MS Clustering in Win2K/3K server environment

You should also possess:

• Strong verbal, written communications, and listening skills
• Strong team player with the ability to build relationships across work units
• Strong customer service skills and follow-up
• Exceptional problem determination, troubleshooting, and resolution skills
• Ability to mentor team members and provide ongoing knowledge transfers relating technology evolution, troubleshooting techniques, and automation.
• Ability to be a team player
• Ability to work under stress
• Process oriented in change and problem management disciplines

Attributes:

• Analytical / Systematic Thinker
• Results Oriented
• Agile / Adaptable
• Relationship Building
• Accountability

Knowledge Transfer:

• Ability to disseminate knowledge to other team members (peer-level communication and knowledge transfer)
• Ability to interact and collaborate with senior-level engineering and architecture staff members on concepts, planning, and new technical policies and procedures.

Special conditions:

• Provide on-call/pager support on a rotational basis
• Visual effort (viewing display terminals, reading complex / fine print documents), for more than ¾ of the time.
• Continuously changing and dynamic environment
• Continuous learning of new IT related tools to support monitoring and operational requirements
• Daily travel within the region may be required

Skills:

• DB2
• Oracle
• Accountability
• Agile/Adaptable
• Analytic/Systematic Thinking
• Relationship Building
• Results Orientation

How to apply for this position:

• Please forward your resume in text format to adnans AT above domain