Senior Database Administrator

Posted 12 Days Ago
Be an Early Applicant
Hyderabad, Telangana, IND
In-Office
Senior level
Fintech
The Role
Manage and optimize enterprise Oracle, Microsoft SQL Server, and Vertica database environments supporting mission-critical OLTP, OLAP, and data warehouse systems. Responsibilities include performance tuning, monitoring, capacity planning, security controls, high availability, disaster recovery, database standards, lifecycle management, troubleshooting, and architecture documentation. The role provides technical leadership, mentors junior staff, participates in on-call support, and collaborates with stakeholders to maintain reliable, highly available database services.
Summary Generated by Built In
Overview

This position is for a Senior Database Administrator. The successful candidate will maintain Oracle & MSSQL Server database environments in an enterprise consisting of approximately 500+ 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.
Qualifications
  • At least 8+ years of relevant experience in managing Oracle server databases versions 10g, 11g, 12c 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, 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, 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)

Skills Required

  • At least 8 years of relevant experience managing Oracle server databases
  • Experience with large-scale OLTP and OLAP systems in mission-critical environments
  • Experience with Oracle 11g/12c or later, Oracle RAC, Grid Control, Data Pump, Data Guard, GoldenGate, Oracle Directory Services, Enterprise Manager, Cloud Control, performance tuning, and resource management
  • Hands-on Oracle Exadata administration and performance tuning experience
  • Experience with Oracle, Microsoft SQL Server, Vertica, or MySQL database technologies
  • In-depth knowledge of database internals and data structures
  • Hands-on database optimization and tuning experience
  • Expertise in SQL, SQL*Plus, PL/SQL, and Unix Shell or Perl scripting
  • Knowledge of database security hardening, identity management, and access controls
  • Knowledge of HIPAA and PCI standards
  • Project management skills and ability to track and report progress against milestones, metrics, and deliverables
  • Strong verbal and written communication skills with customer service orientation
  • Ability to work effectively in a team, multitask, and operate with minimal supervision
  • Oracle Certified Professional or Oracle Certified Expert certification
  • Vertica administration experience and expertise in VSQL
  • Knowledge of Vertica database architecture, compression, projections, segmentations, partitions, high availability, recovery, and security
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Atlanta, Georgia

What We Do

Connolly is a recovery auditing services company focused on healthcare, retail, and commercial businesses.

Similar Jobs

In-Office
Hyderabad, Telangana, IND
115 Employees
In-Office
Hyderabad, Telangana, IND
200 Employees
Hybrid
Hyderabad, Telangana, IND
1132 Employees
In-Office
Hyderabad, Telangana, IND
2380 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account