We provide IT Staff Augmentation Services!

Technology Consultant - Cloud (senior Dba) Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • A professional, self - motivated and delivery-oriented technologist wif more than 16 years of experience in supporting enterprise level Databases and Applications in most recognizable IT and Airline industry. Experienced in leading the projects and partnered wif application support/business to execute continuous engagement plan in order to keep the ERP Application and Database system operations in-line.
  • Experienced in Implementation/Administration of Oracle high availability and disaster recovery solutions such as Real Application Cluster (RAC), Advance Data Guard (ADG) and Enterprise Manager Cloud control. Experienced in Database Performance tuning, Database Migration on various platforms and versions.
  • Proficient in Oracle E-Business Suite R12.1.x and R12.2.x system administration including installation, cloning, patch management and upgrades. Experienced in Capacity Management, Hardware sizing, Storage and Network for the Oracle Database, ERP and Fusion Middleware products.
  • Expert in analyzing user problems, system bottlenecks and identifying root cause, resolving complex issues by working in conjunction wif Problem Management and other Technical Managers of IT Teams. Responsible for ensuring that all security policies, standards and patches are identified, review and access for their impact on the relevant environments and implement them accordingly
  • Strong noledge of ITIL oriented service delivery and Agile methodologies like release, change, incident, and problem management, Jira Board, Kanban, sprint planning etc. Coached, mentored, and facilitated to build expertise. Encourage on going learning and noledge sharing to improve the overall effectiveness and performance of the team

TECHNICAL SKILLS

Databases: Oracle Database 11g, 12c, 18c and 19c, MS SQL Server 2008 R2 / 2016

ERP Application: Oracle E-Business Suit R12.1.x/ R12.2.x.

Web Application: Oracle Application Server 10g, Oracle Fusion Middleware 11g, Java/Apache/forms and reports.

High Availability & DR: RAC 11g/12c and 19c, Active Data-Guard, ASM, Grid Infrastructure, Flashback, Golden Gate, MS SQL Server Log shipping, Replication, Mirroring and Clustering.

Oracle Tools: TKPROF, AWR, AD-Utilities, SRVCTL, CRSCTL ASMCMD, OPMNCTL, RMAN, Oracle Enterprise Manager 12c/13c Cloud Control, SQL, PL/SQL

Operating System: Red Hat Linux, AIX, Sun Solaris and Windows Server.

Tools: & Utilities: ITIL tool such as HP-Service Desk, Service Now, Scrum/Lean and Agile practices, Jira/confluence, iPlan organizer and TOAD, PL/SQL developer

Backup Solution: Hitachi Tivoli TSM / Symantec Net-backup

PROFESSIONAL EXPERIENCE

Technology Consultant - Cloud (Senior DBA)

Confidential

Responsibilities:

  • Working as a Senior database administrator in Confidential for one of the largest banks in Canada.
  • Providing support to ongoing projects such as database upgrades, Exadata Patching, Server Builds and migrations.
  • Administration of Oracle databases on different version 11g/12c/19c.
  • Active Data Guard setup, administration and maintenance for cross site resiliency.
  • Administration, upgrade and support of Oracle 12cR2/ 19c Grid Infrastructure (GI), Real Application Cluster (RAC) and Automatic Storage Management (ASM) for high availability.
  • Backup and restore databases using RMAN.
  • Applying Database security patches, perform maintenance and remediation of database vulnerabilities on physical and virtual servers including EXADATA
  • Identifying performance issues and perform tuning of the database using various tools like AWR, ADDM, SQL Tracing, TKPROF, SQL Profile and OEM 12c/13c
  • Working wif the application development team and provide support to maintain database architectures and coding standards and halp debugging the issues.
  • Testing and validation of changes, fixing errors and making necessary modifications to packages and procedures to promote the same into production.
  • Providing technical support to the application teams in all phases of projects i.e. database design, application development and other weekend and month end activities.
  • Supporting multiple applications and interfaces accessing the databases.
  • Administration and controlling user access / system security and database audit.
  • Collaborating and providing guidance to team members.
  • Providing after office hour and weekend support on a monthly roster.

Senior Technical Engineer (Lead DBA)

Confidential

Responsibilities:

  • Administration of Oracle databases on different version 11g/12c/19c.
  • Active Data Guard setup, administration and maintenance for cross site resiliency for ERP and non-ERP databases.
  • Administration, upgrade and support of Oracle 12cR2/ 19c Grid Infrastructure (GI), Real Application Cluster (RAC) and Automatic Storage Management (ASM) for high availability.
  • Setting-up backup strategies through RMAN using Symantec NetBackup solution on daily/weekly/monthly basis and setup adequate (FRA) Flash Recovery Area for a quick recovery.
  • Ensure backup validity by periodic restoration of the backups from the tape.
  • Administration and controlling user access / system security, encryption and database audit.
  • Apply Database security patches and remediation of database vulnerabilities.
  • Setup database security profiles for DB/APPS users in compliance wif PCIDSS Security Standards.
  • Identify performance issues and perform tuning of the database using various tools like AWR, ADDM, SQL Tracing, TKPROF, SQL Profile and OEM 12c/13c.
  • Administration of Oracle ERP Applications R12.1.3 and R12.2.9 on a single and multi-node environment wif RAC DB wif Shared APPL TOP and Load Balancing.
  • Perform maintenance through AD utilities e.g. ADPATCH, ADOP, ADCTRL, ADRELINK, ADCONFIG, ADCMCTL etc.
  • Perform Database and EBS Application cloning to development/staging/UAT instances periodically on single and multi-nodes and convert Non-CDB-PDB to a CDB-PDB environments.
  • Perform E-Business Suit online patching on different production and non-production instances.
  • Perform Database and EBS application upgrades and apply data fix & bug fixes.
  • Oracle Application Server 10g and Oracle Fusion Middleware 11g administration.
  • Setup MS SQL Server failover cluster, log shipping and mirroring for cross site resiliency.
  • Monitoring, configuration and troubleshooting of Concurrent managers (PCP), load balancer & Workflow mailers notifications.
  • Experience in managing and supporting Oracle Databases on Exadata Appliance servers.
  • Testing and validation of changes, fix errors and make necessary modifications to promote the same into production.
  • Interaction wif software vendors for product support and enhancements, raising SRs to resolve any critical issues & bug fixes.
  • Provide technical support to the application support teams in all phases of projects i.e. database design, application development and other Weekend and Month end activities.
  • Capacity monitoring, database Server consolidations and virtualization for cost and resource optimization

IT Consultant (DBA)

Confidential

Responsibilities:

  • Implementation and upgrade of RAPID (Revenue Accounting System) software for Airline customers and provided post implementation support.
  • Implementation involved on and off-site database administration, design, security configuration and access permissions for RAPID
  • Installation, configuration and administrations of Oracle Database.
  • Installation and configuration of Application Server 10g and setup environment for RAPID application.
  • Performed Database and application migration from Oracle database 9i to 10g and forms 6i to 9i.
  • Provided technical support to various external RAPID customers including patching, cloning and upgrades.
  • Setup RMAN for online backups.
  • Troubleshoot performance and application related issues, provided solutions and implemented the same for customers
  • Delivered technical training to customers and making them acquainted to technical terminologies and database features used by RAPID.

Senior Officer (DBA)

Confidential

Responsibilities:

  • Responsible for Database Administration & design, backup & recovery, disaster recovery, performance tuning.
  • Administrated for Oracle 7.3.4, 8i and 9i databases on Linux Platform.
  • Responsible for installation of Redhat Linux Enterprise 4 and Oracle 9i database software on Servers.
  • Involved in the physical and logical design of a database, as well as configuring security and access permissions
  • Performed database cloning from production to development instances as and when required.
  • Implemented Oracle 9i Data Guard for disaster recovery
  • Troubleshoot Database performance related issues using stats pack report/generate explain plan and provide solution by SQL tuning, indexing and defragmentation.
  • Managed backup and recovery through RMAN.
  • Provided support to the application developers and users.
  • Replication of Database objects through SNAPSHOTS across site.
  • Managed and Audited User’s Schemas, Roles and Security.
  • Implemented automatic monitoring of alert logs via email & SMS.
  • Ensured disk space utilization and Capacity planning of the Databases

We'd love your feedback!