• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 13th Jul 2021

·         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.

·         6+ years of DBA experience, managing Oracle & PostgreSQL databases,

·         3+ 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