Senior Database Administrator

This position is for a Senior Database Administrator. The successful candidate will maintain Oracle and MSSQL Server database environments in an enterprise consisting of approximately 500+ servers. You will work with a distributed team of DBAs 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, and Vertica technologies but may evolve to include other data warehousing solutions in the 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 and 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.
• Perform proactive and reactive performance analysis, monitoring, troubleshooting, and root-cause analysis of database-related issues in support of critical day-to-day business operations.
• Establish and enforce consistent database standards, installation best practices, access protocols, profiling and benchmarking, and development, execution, and measurement of effective service level agreements.
• Perform database capacity planning and ensure efficient utilization of database resources based on performance, growth, and utilization trends.
• Ensure high availability (>99.0%) of critical database systems and services and develop, implement, and test failover and recovery plans for all critical database systems.
• Participate 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.

Qualifications:

• At least 8+ years of relevant experience in managing Oracle server databases versions 10g, 11g, 12c, and later.
• 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, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, GoldenGate, 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 hands-on 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 is a plus.
• Demonstrated project management skills and ability to track and report progress against established milestones, metrics, and deliverables.
• Demonstrated verbal and written communication skills with strong customer service orientation.
• Positive attitude, ability to work in a team, and ability to multitask in a fast-paced environment with minimal supervision.

Other Skills:

• Ability to work in a rapidly changing environment and willingness to learn other database technologies (Oracle, Vertica, etc.).
• Oracle Certified Professional (OCP) and/or Oracle Certified Expert (OCE) certifications will be an advantage.
• Prior experience demonstrating 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, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, Oracle Streams, Oracle Directory Services, Oracle Enterprise Manager, and Oracle Cloud Control. Experience with Exadata is a 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).

Skills

Data Guard, Exadata, GoldenGate, MS SQL, MySQL, Oracle, Oracle Enterprise Manager, Oracle RAC, PL/SQL, Perl, SQL, SQL Server, Unix Shell, Vertica