Team Lead - Database Administrator

Job Title: Team Lead - Database Administrator

Location: Hyderabad (Work from office only). Candidate looking for remote working need not apply.

Summary:

In-Depth experience with 6-8 years Of SQL ,Postgre sql and Oracle. Experience in resource planning/management and source control.

Experience in working with mission-critical applications that require 24/7 uptime.

Experienced DBA involved with backups, recovery, replication, and migration of databases. Experience with user administration and performance tuning.

Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups and Block recovery solutions using RMAN/ manual procedures wherever applicable.

Performance tuning on large systems on Oracle and PostgreSQL.

Experience in consolidating and virtualizing environments.

Experience in building and maintaining DEV, QA, UAT, PROD, and Disaster Recovery environments.

Strong experience performing Oracle Database installations, upgrades, and patch installations.

Responsibilities:

• Strong knowledge of MSSQL, Oracle & PostgreSQL Architecture.
• Oracle and PostgreSQL Database installation, maintenance, and upgrades.
• Experience on applying Oracle, SQL and PostgreSQL patches including CPU patch, interim patch and bugs fixing using OPatch.
• Established database backup/recovery strategy for different databases : Oracle, Mssql and PostgreSQL
• Performed cloning of database from production database to test
• Database Object optimizations, explain plan, query plan and supporting development team on Stored procedures and triggering and others
• Creating and Maintaining Physical Standby database for both PostgreSQL & Oracle
• Experience on RAC databases
• Managing logical backups using datapump utility.
• Working on automation scripts for production databases.
• Automated database environment using SHELL SCRIPTS to monitor different environments.
• Monitor hardware resource utilization, recommending to management additional hardware necessary for forecasted levels, working with staff to maximize performance
• Perform testing of designed transaction processing environment, testing for performance, stability, fail over, and new database versions
• Keep up to date on current and new releases of database platforms and technology, planning migration strategy accordingly
• Assist in the development of automation scripts, documentation, and procedures for database administration, testing, and production
• Database Transit and Encryption

Ensure data integrity and security according to departmental standards and procedures.

• Backup Management

- Using RMAN

- Taking export Backups Through datadumputility.

- Recovery Management

• Working on Goldengate replication, Monitoring and troubleshooting Lag issues
• Prepared scripts for database monitoring and other space alerts
• Good Communication and Interpersonal Skills.
• Experience in PostgreSQL Database with latest versions.
• PostgreSQL Streaming replication
• Experience in working different OS platforms in Linux(Ubuntu, RHEL) and Windows

Education: B.E / B.Tech. graduate

Experience: 6+ Years

Technical Skills:

1) Mssql, oracle & Postgre sql ( any 2 Databases Knowledge)

2) Both Linux & windows Experience

3) Shell/power shell scripting Knowledge

4)Working on HA -Mssql clustering, Postgre SQL Replication, Datagaurd etc.