Bengaluru, Karnataka, India
• 16+ years of experience, responsible for planning, developing, and implementing IT solutions using Oracle, Postgres SQL, MySQL, Cassandra and MongoDB. Breadth of knowledge and experience in data management, design and database administration from a variety of positions and industries. Expertise includes researching problems and resolving situations with cost-saving solutions. • Have Experience of 3+ Years in PostgreSQL DBA, MySQL, Cassandra & MongoDB as well. • Awareness of Cloud Infrastructure (GCP) have solid knowledge of SQL. • Installation & configuration of Oracle 9i/10g/11g/12c/18c/19c (Standalone & RAC) on UNIX, HP-UX, LINUX, SunOS. • Installation & configuration of MySQL 5.7/5.8 & PostgreSQL 9.3.6/9.5 on UNIX, HP-UX, LINUX, CENTOS. • Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation. • Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Vendor Support for bugs & issues resolutions and personal research. • Expertise in maintaining Database Security using auditing. • Experience on Script Programming using Korn shell, bash shell, Perl, awk and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like RedHat, AIX. • Ability to function successfully in a highly stressful, 24x7 mission critical environment. • Excellent analytical and problem-solving skills.
• Monitor and maintain our pool of databases (Oracle, Postgres, MySQL, MongoDB, Cassandra). • Develop procedures/automations/kits to be used by support/cloud production engineers. • Work with peers (SREs, Application Engineers) to roll out changes to our production environment and help migrate database related production incidents. • Environment: Oracle 19c, PostgreSQL 9.5, MySQL 5.8, Cassandra, MongoDB, Terraform, Ansible, GIT (BitBucket), Jenkins, Centos.
• Allocating system storage and planning future storage requirements for the database system. • Upgraded oracle 9i to 10g, 10g to 11g to 12c, 12c to 19c (Standalone & RAC) databases. • Perform DML, DDL activities based on user requirements • Execute CR/TR as requested by developer. • Ongoing DBA Operations management with DB ranging in size of 80 GB to 5 TB. • Responsible to apply patch on Dev and Prod databases. • Work with development teams in resolving and database related issues. • Make selected changes to improve security, recoverability, and ease-of-use. • Supported 24*7 Production environments. • Resolved On–Call issues including Monitoring, Ticket resolution and Work/ Change requests. • Installation of PostgreSQL 9.5 on Unix/Linux, Aix Servers. • Migration from Oracle database to PostgreSQL using Ora2pg tool. • Perform SQL Tuning and other DB monitoring (DB instance management only). • Possess good expertise on Oracle database developments as well as thorough knowledge of scripting in UNIX environment. • Provide day-to-day support to application developer. • Implemented Postgres configuration Replication, Backup and Restorations using Patroni. • Upgrade/Migrate and installed SOX security on more than 100 DBs (including Dev, QA and PROD environments). • As Application DBA, work with developer day to day to improve database performance, stability, security and capacity. • Work on complete SDLC and implement/test required new features and also troubleshoot existing issues. • During this project I did install Oracle’s software, create DBs, setup RMAN backups, setup maintenance Jobs, and Setup cron jobs for all above DBs. • Migration from Oracle database to PostgreSQL using Ora2pg tool
• Perform day-to-day PROD/DEV (Standalone & RAC) database activities based on requests submitted by work streams. • Support multiple production and Final database environments. • Maintain database objects like tables, Views and Procedures based on request. • Perform DML, DDL activities based on user requested. • Execute SQL & scripts on the database instances. • Work with development teams in resolving and database related issues. • Perform SQL Tuning and other DB monitoring (DB instance management only). • Possess good expertise on Oracle database developments as well as thorough knowledge of scripting in UNIX environment. • Perform access management and pro-active DB monitoring. • Provide day-to-day support to application developer. • Review and enhanced instance cloning techniques. • Provide feedback to development partners on tuning opportunities from what is seen in production. • Setting up Physical Standby Database in remote location for Disaster Recovery. • Monitoring and optimizing the performance of the databases. • Design of backup/recovery strategies. • Allocating system storage and planning future storage requirements for the database. • Involved in design of databases, defining of roles, profiles, performance issue, connectivity to database, and creation of database link. • Improve recovery process using Replication, Backup/Recovery (Operating system and RMAN)
• Installing and upgrading the Oracle Server and application tools. • Support & Maintenance of Production/Development (Standalone) Databases. • Migration from Oracle 9i to 10g. • Accomplish day-to-day requirements of User Community. • Automating the process/scheduling job using DBMS_JOB. • Creation of database based on specification. • Monitoring and optimizing the performance of the databases. • Design of backup/recovery strategies. • Allocating system storage and planning future storage requirements for the database. • Involved in design of databases, defining of roles, profiles, performance issue, connectivity to database, and creation of database link. • Investigate suspicious database activity thru auditing. • Improve recovery process using Replication, Backup/Recovery (Operating system and RMAN). • Implementation of Oracle database Patches. • Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. • Test backup/restore procedures and Disaster recovery procedures for production databases using RMAN. • Coordinate with Unix Administrators for space management on various servers. Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.