Senior Dba Resume
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.
