Senior Database Administrator

About Us: ToCumulus Technology Solutions is a leading IT solutions provider specializing in cloud transformation, application modernization, and digital innovation. We are committed to helping enterprises like ADNOC accelerate their digital journey and modernize their legacy applications. Job description: The Senior DBA is a key member of DCOps and will be responsible in the area of DB & design, sizing, support and maintenance. Candidate must have an in-depth understanding of the technology, trend and technical components of databases (Oracle, MSql, MySQL, Postgress & Redshift, AWS RDS, Aurora MySQL, Aurora Postgres) and be able to provide advice to the application teams. The Candidate must collaborate closely with a large contingent of others throughout the Organization and external vendors. The collaboration is both prior to any deployment of equipment, software, applications, IT policies or processes and in post-deployment, development of improvements plan or procedures. Location : Chennai What will you be doing?· Administration of PostgreSQL databases · Should have good knowledge about MySQL, Microsoft SQL Server. · Intimate Knowledge of the Oracle RDBMS database administration and Golden Gate Replication best practices · In-Depth Knowledge and experience of RAC,RMAN,DataPump,Oracle 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 issues 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 AIX,Windows What you will bring along · Minimum 7-10 years of related experience, preferably at a financial institution. 5+ years of corporate IT Infrastructure support management experience in a large-scale production environment with support teams for diversified business applications · 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 AIX,Window Why Join Us? Be part of a transformative project with leading enterprise clients. Opportunity to work with cutting-edge cloud technologies. Collaborative and innovative work environment. Competitive salary and benefits.