Senior Oracle Database Administrator

Description:
This position is for an Oracle Database Administrator. The successful candidate will maintain Oracle database environments in an enterprise consisting of approximately 200+ servers. You will work with a distributed team of DBA's to manage and support key enterprise database systems that provide critical data processing services to internal and client-facing business applications and services. These database systems are primarily based on Oracle, Microsoft SQL Server & Vertica technologies but may evolve to include other data warehousing solutions in near future. You will be required to collaborate effectively with internal and external stakeholders to ensure that these database platforms are highly available, optimally configured and efficiently managed, and for the operational support of large production EDW systems. This is an extremely challenging role that demands strong technical leadership, communication, analytical and problem-solving skills.

Responsibilities:

• Manage Oracle Database Systems and maintain enterprise OLTP, OLAP databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Detect critical deficiencies and recommend solutions for performance improvement and document all architecture design and analysis work
• Plan, build, deploy and maintain enterprise OLTP and OLAP based EDW platforms and services. This includes proactive monitoring and tracking, and relevant data analysis and reporting.
• Pro-active and reactive performance analysis, monitoring, troubleshooting and root-cause analysis of database related issues in support of critical day-to-day business operations.
• Responsible for establishing and enforcing consistent database standards, installation best practices, access protocols, profiling and benchmarking, and development, execution and measurement of effective service level agreements.
• Responsible for database capacity planning and efficient utilization of database resources based on performance, growth and utilization trends.
• Responsible for ensuring high-availability (>99.0%) of critical database systems and services and development, implementation and testing of failover and recovery plans for all critical database systems.
• Participates in the setting of objectives, strategies, plans, programs, performance standards/measures and procedures, as a member of the IT leadership team.
• Participate in on-call system administration support including but not limited to weekends, holidays and after-business hours as required to service the needs of the business.
• Provide mentoring and guidance to junior technical team members.

Requirements:

• At least 5-8 plus years of relevant experience in managing Oracle server databases versions 11g, 12c, 19c and later
• Demonstrated a thorough knowledge and progressively responsible experience in implementation and maintenance of large-scale OLTP and OLAP systems in mission-critical environments including, but not limited to, Oracle 11g/12c/19c, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, Golden Gate, Oracle Directory Services, Oracle Enterprise Manager, Oracle Cloud Control, Oracle Database Performance Tuning and Database Resource Management on Exadata Systems.
• Oracle Exadata Database Machine Administration and Performance tuning based on-hands experience
• Experience and expertise with at least one of the database technologies used in our products, preferably Oracle but also interested in MSSQL and/or Vertica and/or MySQL knowledge.
• Demonstrated in-depth knowledge of database internals and data structures. Hands-on experience with database optimization and tuning.
• Excellent hands-on expertise in SQL/SQL*Plus, PL/SQL, and Unix Shell or Perl scripting.
• Knowledge of formal information security standards and best practices, including database system hardening, identity management, and database access controls. Knowledge of HIPAA and PCI standards a plus.
• Demonstrated project management skills and ability to track and report progress against established milestones, metrics and deliverables.
• Demonstrated verbal and written communications skills with strong customer service orientation.
• Positive attitude, ability to work in a team and ability to multi-task in a fast-paced environment with minimal supervision

Other Skills:

• Ability to work in a rapidly changing environment and willing to learn other database technologies (Oracle, Vertica, etc.)
• Oracle Certified Professional (OCP) and/or Oracle Certified Expert (OCE) certifications will be advantage
• Prior experience demonstrated thorough knowledge and progressively responsible experience in implementation and maintenance of large-scale OLTP and OLAP systems in mission-critical environments including, but not limited to, Oracle 11g/12c/19c, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, Oracle Streams, Oracle Directory Services, Oracle Enterprise Manager, Oracle Cloud Control. Experience with Exadata is plus.
• Prior experience with Vertica Administration and expertise in VSQL. Good working knowledge of Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and recovery, security)