Job description: Sr. DBA Database
Location : Chennai
Experience : 4yrs
Notice period : Immediate to 15 days
What will you be doing
- A dministration of PostgreSQL databases
- Should have good knowledge about MySQLMicrosoft SQL Server.
- Intimate Knowledge of the Oracle RDBMS database administration and Golden Gate Replication best practices
- In-Depth Knowledge and experience of RACRMANDataPumpOracle Data Guard/Golden Gate replication and physical standby for Disaster recovery.
- Experiences to address database alerts/issues capacity constraints and performance related items.
- Fully analyze performance issues in most critical and performance sensitive Oracle databases.
- Identify tuning opportunities; implement improvements and advice developers on SQL tuning options.
- Superior analytical and problem-solving skills
- Database Monitoring
- Database performance tuning
- Database upgrade and migration
- Automation in monitoring and maintenance
- Regular Database Maintenance
- Implementation of DDL and DML request
- Purging Tracking and execution
- Database patching
- Closure of Database security vulnerabilities
- Monitor and maintain the backups for database recoverability
- Team management and grooming new skill
- Suggest Improvement and recommendations for DB
- Best practices implementation
- Driving Root Cause Analysis for DB issues or issue impacting DB
- Problem Management
- Set-up failover cluster
- Set-up streaming and logical replication
- Understanding of basic Infrastructure implementation required to ensure optimal DB performance.
- Experience in OS - redhat Linux Sun Solaris IBM AIXWindows
-
What you will bring along
- Strong experience with design installation configuration testing migration and implementation as well as Administration experience of MS SQL Postgres Oracle MSSQL database Microsoft SQL Server.
- Strong experience in configuring provisioning and performance tuning AWS RDS Aurora MySQL and Aurora PostgreSQL.
- Develop data migration plans to migrate legacy on-premises databases to new environments (Knowledge of cloud data stores would be a plus)
- Excellent understanding of Oracle SQL / PL/SQL skills and Performance tuning Deep knowledge of Oracle partitioning Indexing and Compression Experience developing complex business logic in the Oracle database using PL/SQL.
- Proven experience with any Identity authentication and authorization systems
- Installation and management of security certificates
- Scripting skills to automate jobs and ability to write and revise bash/ksh/batch/WLST scripts
- Strong hands-on experience with the Oracle RMAN Backup and Restore Point-in-time recovery Export and Import Data Pump utilities and partitioning Oracle databases
- Leverage tools like OEM AWR ASH ADDM Expdp/Impdp SQL Tuning Advisor SQL Plan Baselines
- Solid knowledge of database and application triggers stored procedures PL/SQL Linux/Windows environments and third-party tools such as Toad and OEM.
- Good understanding and experience with various operating systems (Linux (preferably Red Hat) Windows etc.)
- Good written verbal interpersonal and communication skills; easily translatable between technical and business audiences.
- Bachelor s degree from an accredited college/university.
- Demonstrated track record of effectively managing infrastructure teams
- Aptitude and desire to learn new technologies.
- Excellent understanding in OS - redhat Linux Sun Solaris IBM AIXWindows
If interested please share your resume with Also dont forget to follow our company page @Ample Success Hr Solutions for regular updates on job openings.
Job description: Sr. DBA Database Location : Chennai Experience : 4yrs Notice period : Immediate to 15 days What will you be doing A dministration of PostgreSQL databases Should have good knowledge about MySQLMicrosoft SQL Server. Intimate Knowledge of the Oracle RDBMS database administra...
Job description: Sr. DBA Database
Location : Chennai
Experience : 4yrs
Notice period : Immediate to 15 days
What will you be doing
- A dministration of PostgreSQL databases
- Should have good knowledge about MySQLMicrosoft SQL Server.
- Intimate Knowledge of the Oracle RDBMS database administration and Golden Gate Replication best practices
- In-Depth Knowledge and experience of RACRMANDataPumpOracle Data Guard/Golden Gate replication and physical standby for Disaster recovery.
- Experiences to address database alerts/issues capacity constraints and performance related items.
- Fully analyze performance issues in most critical and performance sensitive Oracle databases.
- Identify tuning opportunities; implement improvements and advice developers on SQL tuning options.
- Superior analytical and problem-solving skills
- Database Monitoring
- Database performance tuning
- Database upgrade and migration
- Automation in monitoring and maintenance
- Regular Database Maintenance
- Implementation of DDL and DML request
- Purging Tracking and execution
- Database patching
- Closure of Database security vulnerabilities
- Monitor and maintain the backups for database recoverability
- Team management and grooming new skill
- Suggest Improvement and recommendations for DB
- Best practices implementation
- Driving Root Cause Analysis for DB issues or issue impacting DB
- Problem Management
- Set-up failover cluster
- Set-up streaming and logical replication
- Understanding of basic Infrastructure implementation required to ensure optimal DB performance.
- Experience in OS - redhat Linux Sun Solaris IBM AIXWindows
-
What you will bring along
- Strong experience with design installation configuration testing migration and implementation as well as Administration experience of MS SQL Postgres Oracle MSSQL database Microsoft SQL Server.
- Strong experience in configuring provisioning and performance tuning AWS RDS Aurora MySQL and Aurora PostgreSQL.
- Develop data migration plans to migrate legacy on-premises databases to new environments (Knowledge of cloud data stores would be a plus)
- Excellent understanding of Oracle SQL / PL/SQL skills and Performance tuning Deep knowledge of Oracle partitioning Indexing and Compression Experience developing complex business logic in the Oracle database using PL/SQL.
- Proven experience with any Identity authentication and authorization systems
- Installation and management of security certificates
- Scripting skills to automate jobs and ability to write and revise bash/ksh/batch/WLST scripts
- Strong hands-on experience with the Oracle RMAN Backup and Restore Point-in-time recovery Export and Import Data Pump utilities and partitioning Oracle databases
- Leverage tools like OEM AWR ASH ADDM Expdp/Impdp SQL Tuning Advisor SQL Plan Baselines
- Solid knowledge of database and application triggers stored procedures PL/SQL Linux/Windows environments and third-party tools such as Toad and OEM.
- Good understanding and experience with various operating systems (Linux (preferably Red Hat) Windows etc.)
- Good written verbal interpersonal and communication skills; easily translatable between technical and business audiences.
- Bachelor s degree from an accredited college/university.
- Demonstrated track record of effectively managing infrastructure teams
- Aptitude and desire to learn new technologies.
- Excellent understanding in OS - redhat Linux Sun Solaris IBM AIXWindows
If interested please share your resume with Also dont forget to follow our company page @Ample Success Hr Solutions for regular updates on job openings.
View more
View less