Manage, support and maintain database technology and infrastructure, adhering to the architectural guidelines and policies.
Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call rotation.
Install, configure, monitor, upgrade and maintain Oracle and PostgreSQL databases in production and non-production environments.
Support local/across the DC failover with High Availability Disaster Recovery environment (with Data Guard & Golden Gate for Oracle and Streaming & Logical Replications for PostgreSQL). Participate in Database Maintenance and DR activities.
Write/maintain Shell/Python scripts for DB automation.
Physical implementation of databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.
Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of escalated Level 2 and Level3 issues.
Regular database capacity planning related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
Work closely with other Infrastructure engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA’s and performance targets.
Adapt business requirements, model data, and develop database specifications, table and element attributes.
Ability to work well as a team and as an individual with minimal supervision
REQUIREMENTS
Bachelor or Master Degree in Computer Science or related field is a must.
7-10 years of DBA experience, managing Oracle & PostgreSQL databases,
4-5 years of experience managing complex bi-directional replication topology
Strong understanding of Oracle & PostgreSQL database fundamentals and Architecture.
Strong understanding of Oracle GoldenGate fundamentals
Strong understanding of Oracle DataGuard fundamentals
Strong understanding of Oracle & PostgreSQL database security management
Strong understanding of PostgreSQL streaming and logical replication
Should have good Troubleshooting and Performance Improving Skills including index creation, query optimization, schema changes etc.
Should have strong UNIX platform skills and understanding of network, storage, tiered application environments and security.
Strong knowledge of Operating systems, Shell scripting, Python/Perl scripting
Good knowledge of programming and prior experience will be a plus
Understanding of code versioning tools such as Git