We provide IT Staff Augmentation Services!

Consultant, Database Administration\architect Resume

4.00/5 (Submit Your Rating)

Columbus, OH

SUMMARY:

  • Over 11 years of experience as an Oracle Database Administrator/Architect and 5 years in MS - SQL Database.
  • Installation, configuration administration, and performance tuning of Oracle Clusterware 12C/11G on ASM/ACFS. Upgrading/migration, patching of Oracle 12c/11g Grid, ASM Configuration, Setup, Performance tuning.
  • Experience in Installation and Maintenance of Database and its Tools of various RDBMS versions of Oracle 11g/12c RAC and Standalone environments in OLTP/PLAP environments for High Availability and Disaster Recovery and managed databases (VLDB) of over 8TB in OLTP environments.
  • Managed Oracle/SQL Server databases on Amazon AWS, database migrations to AWS using GoldenGate. Migrated Databases to Amazon RDS and EC2 instances.
  • Expertise in Upgrading Oracle Development and Production databases and ensure that any new product usage or release upgrade takes place with minimal impact and Configuring the network environment to enable clients to connect to the database (ODBC and JDBC).
  • Experience in database CPU/PSU and SECURITY patches to the database in RAC and Standalone Dev and Production environments
  • Setup and Installation, configuration of OEM Cloud Control 12c/13C. Upgraded OEM Cloud Control from 12C to 13C, applying patches, deploying agents, deploying templates, incident management and developed database monitoring/health check alert scripts for database for High Performance, Capacity Planning.
  • Extensive experience in Database Backups using RMAN (Full/Incremental) and traditional hot/cold backups
  • Experience in Database Recovery using conventional hot & cold backups, RMAN and Block Media recovery, Flashback technologies to ensure Business Continuity. RMAN Cloning of databases using Duplicate and Active Duplicate.
  • Experience in Database/Schema Data Migrations using RMAN, DATAPUMP, DB LINKS, TTS, Redgate between the databases. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
  • Installation and Configuration of Oracle DataGuard databases, Physical and Logical, Active DataGuard setup, DG Broker, Failover and Switchover configuration.
  • Experience in Capacity Planning, Storage Reviews required to create and maintain both RAC and Standalone databases for development, testing and production usage.
  • Installation, Upgrade, Configuration, maintenance and performance tuning of Oracle GoldenGate 11g/12C for Uni-Directional, Bi-Directional and Consolidation topologies.
  • Configuration of Oracle Advanced Security by implementing Oracle TDE for 11g/12C databases and Database Redaction for Databases with PCI,PII, HIPPA data. Implemented User and Database security through user profiles, database auditing, Database Hardening through MSB scripts.
  • Implemented Oracle Advanced Compression for tables, Datapump exports, RMAN backups to improve query performance and reduce storage costs.
  • Experience in Carrying out database application performance tuning and testing using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH and ADDM.
  • Good knowledge of Architecture and Physical Database Design.
  • Experience in SQL, UNIX scripting.
  • Experience is DB level OS Administration in Unix/Linux and Windows Server Administration, Storage experience with EMC SAN storages, NFS.
  • Experience in MSSQL Server Database 2008/2012/2014 , Administration, Installation, Support and Performance Tuning using Management Studio.
  • MSSQL Server Backup and Recovery Scenarios of the Database/Schema.
  • Experience in SQL Server DB Mirroring, Log Shipping, Replication, Data Migration.
  • Proficient in SQL Tools such as Data Governance/Compression/Partitioning for SQL Server.
  • Experience working in Waterfall/Agile environments.
  • Excellent/Proven problem-solving skills with Result oriented, Self-motivated, Team Player and Ability to work independently.

TECHNICAL SKILLS:

RDBMS: Oracle 12C/11g/10g RAC, 9i, 8i, MS- SQL Server 2008/2012/2016

Specialization: OLTP, DSS, VLDB, Data Marts

Tools: Grid Control/OEM, TOAD, RMAN, SQL*Loader, DB Artisan, Export, TDE, Data Pump, ASM, VERITAS Cluster, EMC SAN, NAS, Goldengate, Quest, Big Brother, MS SQL Management Studio, TSM, MS-SSIS, MS-SSRS, MS-SSAS, TWS/IWS,Redgate

Languages: SQL, PL/SQL, Shell scripting, Perl

Sun Solaris, HPUX, IBM: AIX, Redhat/SUSE Linux, Windows Server 2008/2012

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Consultant, Database Administration\Architect

Responsibilities:

  • Provided 24*7 database administration and production support and on call rotation.
  • Successfully led the database team for 13 Major Releases and conversion database activity for the project.
  • Provided and Maintained documentation on regular basis for the daily activities and major tasks for implementation and production releases.
  • Supported application databases for PSRM, Peoplesoft, Reporting, ETL, TWS/IWS, and ESB applications. Assisted the team during application upgrades, troubleshooting, application performance tuning, production deployments.
  • Successfully architected a 4-Node RAC on IBM AIX servers and managed OLTP databases of size over 5TB and managed a multi-Terabyte Data warehouse environment.
  • Oracle 12C RAC Grid and Database Installations and Oracle database upgrades from 10g to 11g and 11g to 12C in cluster and standalone environments and applied PSU/CPU patches to RAC and Standalone databases.
  • Oracle 12c Pluggable database conversion, creating new 12c pluggable databases, cloning/migration of pluggable databases.
  • Designed access and security of databases having PCI, PII, HIPPA data. Implemented procedures on the databases for SOX Complaint. User security, role management, access management. Implemented Oracle database Hardening using custom scripts and procedures for validation.
  • Implemented and Configured Oracle 12C TDE for databases by encrypting the tablespaces.
  • Implemented Oracle Advanced Compression for Tables, RMAN backups and DATAPUMP exports/imports and helped save disk space.
  • Implemented table partitioning in conjunction with the application requirements and helped improved the response time of the queries and nightly batch job schedules and improved the performance of the database.
  • Data Management of databases by Monitoring disk space utilizations, sizing, and capacity planning. Adjusting database sizes, predicting the growth.
  • Migrated the data from Oracle 10g to 11g and 11g to 12C and database migration between servers using disk replication, TTS, RMAN duplicate, DATAPUMP tools.
  • Architected and implemented High-availability solutions/Disaster Recovery using ActiveDataGuard. Configured physical standby using RMAN active duplicate, management of ActiveDataGuard, Dataguardbroker setup and monitoring of the DataGuard apply process, troubleshooting delay process.
  • Performed Failover and switchover of DataGuard environments during maintenance for zero-downtime (for High availability).
  • Installation, Upgrade, Configuration, maintenance and performance tuning of Oracle GoldenGate 11g/12C for Uni-Directional, Bi-Directional and Consolidation topologies, Integrated extract and replicat configuration.
  • Experience in database Performance tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ADDM. Performance Tuning of high volume databases (VLDB’s).
  • Improving the SQL queries performance using explain plan and implementing Optimizer Hints, SQL Profiles, SQL Baseline and SQL Plan management.
  • Experience in scripting using Shell. Created custom scripts for database automation, monitoring, management and housekeeping.
  • Installed and configured and upgraded OEM 13C Cloud Control for database servers monitoring. Upgraded OEM from 12C to 13C and migrated to Pluggable databases.
  • Installed MS SQL Server 2008/2012 Database, Configuration and Maintenance.
  • Backup and Recovery of MSSQL Server Database and SQL Server Database Replication, Log Shipping and Data Migration Between SQL Servers.
  • Monitored the database using the SQL Performance tools such as SQL Profiler and DB Tuning Advisor.

Confidential, Scottsdale, AZ

Consultant, Database Administration

Responsibilities:

  • Provided 24*7 database administration and production support and on call rotation.
  • Installed, Configured and Administrated Oracle 11g, 10g, 9i databases in RAC and Standalone environments for E-Commerce and HIPPA related applications on SUN Solaris and RHEL Linux environments.
  • Performed general DBA activities such as user management, tablespace management, and security management of the databases. Monitored disk space utilizations, sizing, and capacity planning.
  • Refresh/Cloned databases from production for Dev & QA environments using RMAN cloning, DATAPUMP, Oracle TTS.
  • Performance Tuning of high volume databases. Experience in Performance tuning of a database using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ASH, ADDM, SQL Profiles, Optimizer Hints, SQL Plan Management.
  • Provided MSB scripts using shell scripting and Set up the User Defined Metrics for the databases as per the requirement. Automated MSB related jobs/scripts. Developed PUSH scripts in Unix to transfer scripts to all the servers.
  • Scripting of reports for Database Hardening, MSB implementations using shell, Perl.

Confidential, Lincolnshire, IL

Consultant, Database Administration

Responsibilities:

  • Provided 24*7 database administration and production support and on call rotation.
  • Involved in migrating a 2TB 10G OLTP standalone database to a 3-node 10G RAC cluster using DATAGUARD and upgrading it to a 11G RAC Cluster.
  • Managed a multi-Terabyte Data warehouse environment.
  • Successfully setup a new 3-node production 11G RAC Cluster using ASM and ACFS filesystems on Solaris environments.
  • Implemented HA solutions for the application database by setting up an Active DataGuard physical standby.
  • Installed, Configured and Administrated Oracle 11g, 10g, 9i databases in RAC and Standalone environments for E-Commerce, POS and ATG applications.
  • Upgrading 10g database to 11g, creating new databases to support customer applications.
  • Provided 24*7 database administration and production support and on call rotation
  • Management of Oracle OEM Cloud Control. Created custom templates for disk managements, database alerts, security.
  • Installation, Upgrade, Configuration, performance tuning of Oracle GoldenGate 11g.
  • Maintenance of GoldenGate for Uni-Directional, Consolidation topologies.
  • Applying database PSU/CPU patches to databases in RAC and Standalone environments.
  • Experience in database Performance tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ADDM. Performance Tuning of high volume databases (VLDB’s).
  • Improving the SQL queries performance using explain plan and implementing Optimizer Hints, SQL Profiles and SQL Plan management.
  • Scripting using shell and Perl.

Confidential, Brisbane, CA

Consultant, Database Administration

Responsibilities:

  • Provided 24*7 database administration and production support and on call rotation.
  • Installation, configuration, performance tuning, and maintenance of Oracle 11g/10g RAC databases
  • Successfully managed a 4-Node and two 6-Node RAC 11g database environments for E-Commerce applications for the organization.
  • Applied CPU/PSU patches to the databases in RAC and standalone environments.
  • Migrated the data from Oracle 10g to Oracle 11g on both RAC and Non-RAC databases.
  • Refresh/Cloned databases from production for Dev & QA environments using RMAN duplicate and RMAN active duplication, DATAPUMP, Oracle TTS.
  • Managed Oracle DataGuard environments, DataGuard broker setup, switchover, failover and troubleshooting DataGuard issues.
  • Installation, Upgrade, Configuration, performance tuning of Oracle GoldenGate 11g.
  • Maintenance of GoldenGate for Uni-Directional, Consolidation topologies.
  • Management of Oracle OEM Cloud Control. Created custom templates for disk managements, database alerts, security.
  • Improving the SQL queries performance using explain plan and implementing Optimizer Hints, SQL Profiles and SQL Plan management.
  • Experience in scripting using shell and Perl.

Confidential

Oracle Database Administrator

Responsibilities:

  • Provided 24*7 database administration and production support and on call rotation.
  • Responsible for the Installation, configuration, performance tuning, and maintenance of Oracle 11g/10g RAC databases
  • Successfully managed a 2-Node RAC database environments for the organization.
  • User management, disk space management, housekeeping of databases using custom scripting.
  • Used oracle DATAPUMP and RMAN to move data between environments, to refresh databases and backup data.
  • Assisted developers in their daily activities and solving business related issues.
  • Applied PSU/CPU Patches to RAC and single-instance database servers.
  • Experience in scripting using Shell and Perl.

We'd love your feedback!