I have been involved in various project initiatives for one of the major pharmaceutical companies in the US and globally. My responsibilities included gathering database requirements, planning, designing, building, and solutioning.

Roles and responsibilities: - Gathering infrastructure requirements, designing, developing, and implementing scalable cloud-based database solutions for various projects. - Establish and ensure that all databases meet standard requirements such as security, reliability, availability, and scalability. - Identify opportunities for optimizing database infrastructure and reducing costs in the AWS cloud. - Performing root cause analysis of all production-related database issues… Show more Roles and responsibilities: - Gathering infrastructure requirements, designing, developing, and implementing scalable cloud-based database solutions for various projects. - Establish and ensure that all databases meet standard requirements such as security, reliability, availability, and scalability. - Identify opportunities for optimizing database infrastructure and reducing costs in the AWS cloud. - Performing root cause analysis of all production-related database issues and implementing corrective and preventive actions. - Develop innovative solutions to complex business and technical problems. - Responsible for physically implementing databases, storage structures, and high-availability solutions, such as multi-AZ, replication, and disaster recovery solutions. - Manage, support, and maintain cloud database environments while adhering to architectural guidelines and policies. - Provide technical expertise and hands-on support in consolidating and migrating databases from on-premises to AWS cloud (EC2 and RDS). - Additionally, responsible for implementing Virtual Private Database (VPD) access control on integration databases to securely access market-specific data. - Interact with other IT teams to promote and ensure compliance with Oracle database standards. - Build application databases in EC2, RDS, and other cloud-native databases (MySQL, PostgreSQL, Redshift) in AWS. - Migrate Oracle databases to Redshift using DMS and SCT and migrate to RDS using data pump utilities. - Experience in continuous integration (CI) and Continuous Deployment (CD) environments with Build, Release, and Deployment.- Review DM changes and deploy them in various environments based on Sprint Release plans.- Responsible for managing DBA resources, planning, and utilizing them globally on various database tasks that are part of multiple project deliverables.- Create AWS Redshift Clusters for data warehouse applications and reporting tools. Show less

Roles and responsibilities: - Involved in migrating Oracle data warehouse and local application databases from Germany, Italy, and Spain to a regional data center in Belgium as part of a data center consolidation project. - Migrated several databases in different character sets into AL32UTF8 and consolidated them into HP-UX, Linux, and Solaris servers. - Provided database L3 support for regional databases in EMEA on a 24/7 availability and support model. - Installed Oracle… Show more Roles and responsibilities: - Involved in migrating Oracle data warehouse and local application databases from Germany, Italy, and Spain to a regional data center in Belgium as part of a data center consolidation project. - Migrated several databases in different character sets into AL32UTF8 and consolidated them into HP-UX, Linux, and Solaris servers. - Provided database L3 support for regional databases in EMEA on a 24/7 availability and support model. - Installed Oracle code trees and created OTLP and data warehouse databases for various projects. - Migrated databases from PA-RISC to Itanium and Linux servers as part of a platform modernization project. - My responsibilities also included DB build, upgrade, and patching of Oracle databases in HP-UX, Solaris, and Linux. - Decommissioned application databases and facilitated archiving of the DB using OPTIM. - Participated in Disaster Recovery Exercises for Class-A and Class-B mission-critical applications. - Involved in problem management of incidents, and RCA of all database-related issues in the EMEA Region. - Performed database duplication/cloning using RMAN and database refresh using Data pump utilities.- Performed performance tuning of various critical application databases using AWR, ADDM, EXPLAIN PLAN, SQL Monitoring, etc. to analyze and troubleshoot the issues. - Configured and implemented ASM and proficient in using ASMCMD and ASMLIB, Flash-Back Technology, and Log Miner. - Provided support as a Production Support DBA and application/Project DBA. - Performed Incident, Change, Configuration, and Problem Management using the BMC Remedy tool. - Prepared IQOQ validation documents for database installation, configuration, and operation.- Applied critical patch updates (CPU) released by Oracle quarterly based on the maintenance schedule following client processes.- Conducted in-depth technical problem analysis and resolution for Oracle databases and dependent applications. Show less

- Responsible for the knowledge transition from a Singapore-based vendor to the HCL offshore for one of the major pharmaceutical companies in the US. - Managed database support for over 700+ Oracle databases in the EMEA Region. This included the installation of Oracle 10.2.0.5 binaries on Solaris and HP-UX platforms, creating databases, Quality Gate checks, and backup configurations using RMAN and OEM. - Patched the Oracle home using the Opatch utility to fix different kinds of bugs and… Show more - Responsible for the knowledge transition from a Singapore-based vendor to the HCL offshore for one of the major pharmaceutical companies in the US. - Managed database support for over 700+ Oracle databases in the EMEA Region. This included the installation of Oracle 10.2.0.5 binaries on Solaris and HP-UX platforms, creating databases, Quality Gate checks, and backup configurations using RMAN and OEM. - Patched the Oracle home using the Opatch utility to fix different kinds of bugs and coordinated with the UNIX and Linux teams for OS-level security patching. - Refreshed application schemas and tables from production to non-prod environments using exp/imp and data pump utilities, and cloned Oracle databases using RMAN. - Created users, roles, and profiles based on standard naming conventions and followed the client processes. - Attended GOC calls for production issues, developed corrective and preventive actions, and created SR with Oracle support for internal errors and bugs. - Troubleshooted production performance issues for OLTP and OLAP application databases. - Carried out SOX DB auditing and monitoring for critical table alerts, login failures, etc.- Provided 24/7 on-call support for production databases in result-oriented and time-critical environments. - Documented the processes and Oracle engineering standards specific to the client and trained the team members. - I was responsible for service level management for the EMEA database group and monitored database alerts from OEM, backup failure, and availability checks for production databases. - Implemented the resource group for better utilization of CPU resources among databases in shared database servers. - Set up ACL/UTL MAIL in the database per the applications' requirements. - Interacted with other IT teams to promote and ensure compliance with Oracle database standards. - Carried out incident, asset, configuration, and change management using Mercury and BMC Remedy. Show less