We provide IT Staff Augmentation Services!

Senior Dba Resume

3.00/5 (Submit Your Rating)

Houston, TX

SUMMARY:

  • An accomplished Database Administrator with demonstrated success designing and implementing database solution that improve business functionality.
  • Possess exceptional background in analysis, design, development, customization, and implementation.
  • Over 20 years of experience in IT industry with 15 years as DBA. Strong working knowledge of Server Virtualization.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 /2005, Oracle 7/8i/9i/10g/11g/12c, Vertica

Roles: System DBA, Application DBA, SAP Basis, DW

Data Modeling: Erwin, TOAD, Data Modeler, Oracle Designer, Relational and Dimensional Modeling

Web Technologies: XML, HTML, Java, JDBC, PL/SQL

Middleware: Oracle Fusion, WebSphere application server, JBoss EAP

Operating Systems: Windows, UNIX, Linux, VMware

Utilities: Oracle Data pump, Export, Import, RMAN, SQL*Loader, Database Tuning Advisor, BCP, SQL Profiler

Scripting Languages: Oracle PL/SQL C, Pro*C, UNIX Shell Scripting, Perl, T - SQL

SQL Tools: SQL Developer, TOAD, SQL Server Management Studio (SSMS)Tools: Oracle Enterprise Manager, SQL*Plus, Oracle Warehouse Builder, Visio, Lotus Notes

I ndustry: Oil & Gas, Health Care, Telecom, Financial

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior DBA

Environment: Oracle 12c/11g RAC, SQL Server, ODA x7, Solaris 11, Oracle fusion, OEM 13.2

  • Provided operational support to all database platforms
  • Managed setup, configuration, maintenance and performance of Oracle databases
  • Administered backup, recovery and environment refreshes

Confidential, Houston, TX

Technical Lead

Environment: SQL Server 2014/2012/2008, Oracle 12c/11g RAC,Red Hat Linux, Windows, VMware, Oracle fusion, JBOSS EAP

  • Formulated a comprehensive migration strategies for migrating data from Shell to Confidential .
  • Developed system wide database standards, guidelines and naming conventions
  • Led team to plan, design, and implement applications and software.
  • Collaborated with business analysts, developers, and technical support teams to define project requirements and specifications.
  • Designed & implemented RAC, data guard for Oracle & cluster for SQL Server.
  • Worked on performance tuning using OEM, AWR, ASH, ADDM, execution plans, SQL Profiler, db Tuning Advisor.
  • Developed and assisted developers with SQL, PL/SQL, T-SQL, stored procedures and triggers.
  • Managed installation, configuration, maintenance and performance of Oracle & SQL Server databases.
  • Worked with various vendors for environment setup (OS, middleware & DB) and application installation.
  • Worked on data model using Erwin & SQL Developer Data Modeler.
  • Worked with server admins to apply OS patches required for database installation.

Confidential, Houston, TX

SENIOR DBA

Environment: Oracle 11g RAC, SQL Server 2012/2008, Red Hat Linux, Windows 2008 R2, VMware

  • Provided operational support to all database platforms
  • Managed setup, configuration, maintenance and performance of Oracle & SQL Servers databases
  • Ensured replication best practices are implemented to maintain DR readiness
  • Performed upgrades, patching and installations of Oracle & SQL Server
  • Participated in planning of strategic direction of a highly available environment including roadmap, processes, and procedures
  • Worked closely with and communicated with cross-functional groups (development, QA, production, systems administration)
  • Administered backup, recovery and environment refreshes
  • Ongoing support of application teams by identifying, researching and resolving performance and database related issues during development, QA lifecycles.
  • Documented database related architecture, best practices and standards.
  • Installed ESXi for VMware. Created linux and windows VM.

Confidential, Chicago, IL

LEAD ORACLE DATABASE ADMINISTRATOR

Environment: Oracle 11g/10g/9i/8, Sun Solaris 10/9, VERITAS Cluster Server, OEM, Vertica

  • Installed Oracle software on UNIX platform (Sun Solaris 10/9/8).
  • Lead a team of 4 for developing strategy & migration plan of database from Oracle 10g to 11g
  • Assisted development team in writing stored procedures & UNIX shell scripts.
  • Planned, coordinated and implemented database migration from one data center to another.
  • Developed and implemented database policies and procedure. Used RMAN (Recovery Manager) as primary backup & recovery software & VERITAS net-backup as media management software.
  • Identify, recommend, and implement all new database technologies.
  • Performed database tuning using statspack, explain plan, hints, utlbstat / utlestat & Enterprise Manager.
  • Extensively worked on Oracle Utilities Data Guard, Data Pump, Flash Back, SQL Loader, and RMAN.
  • Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases.
  • Worked on 3 node Vertica database. Used ascii file to transfer data from DB2 to Vertica. Statistical reports for management were scheduled from this DB.

We'd love your feedback!