• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 30th 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.

•            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