Lead Database Engineer
Depository Trust & Clearing Corporation (DTCC)3 months ago
Hyderābād, IndiaStaff+
Responsibilities
- Architect, design, and implement Oracle databases on AWS RDS for data integrity, security, and high availability.
- Migrate on-premises Oracle platforms to AWS RDS while ensuring post-migration performance, resiliency, and compliance.
- Monitor, analyze, and optimize database performance using AWR, ASH, RDS Performance Insights, CloudWatch, and OEM.
- Support Data Guard, RAC, and GoldenGate microservices.
- Develop, review, and optimize PL/SQL packages, procedures, functions, materialized views, and complex SQL.
- Implement database security controls including encryption, masking, redaction, auditing, and access governance.
- Design and support disaster recovery using automated backups, snapshots, Multi-AZ, and cross-region strategies.
- Participate in production support, on-call rotations, and incident escalations.
- Build collaborative teams and communicate issues and information across the organization.
Requirements
- Minimum 8 years of experience in Oracle Database Engineering or Administration.
- Bachelor’s degree preferred, or equivalent professional experience.
- Hands-on experience with Oracle RDS on AWS and AWS services including CloudWatch, IAM, KMS, VPC, and S3.
- Strong knowledge of PL/SQL coding standards, performance tuning, and database internals.
- Experience with OEM, Grafana, GoldenGate, and related database tooling.
- Familiarity with Agile development methodologies and DevOps collaboration models.
- Experience with pipelines using Git, Bitbucket, Jenkins, Maven, and Jira.
- Proficiency in scripting and automation with Shell, Python, Ansible, and Terraform.
- Understanding of data modeling, schema design, and performance-driven architecture.
- Strong object-oriented programming expertise with hands-on Python or Java implementation experience.
- Oracle ZDLRA knowledge is a plus.
- Strong analytical, problem-solving, written, verbal, and cross-team collaboration skills.
Benefits
- Competitive compensation including base pay and annual incentive.
- Comprehensive health and life insurance and well-being benefits, based on location.
- Pension and retirement benefits.
- Paid time off, personal and family care, and other leaves of absence.
- Flexible hybrid schedule with three days onsite and two days remote; onsite days include Tuesdays, Wednesdays, and a third team-designated day.