Database Administrator Resume
Houston, Texas
SUMMARY:
- An enterprising information technology professional. A tenured SQL Server Database Administrator with experience as an Oracle DBA and a Sybase DBA. Adept at planning, installation, configuration, edition up gradation and migration of SQL Server; ensured successful & smooth completion and execution of all projects well within the given time and quality parameters.
- Comprehensive working exposure across different database projects of Bank of Confidential.
- Expertise in managing multiple projects as per industry standard best practices.
- Distinction of applying services packs and security fixes.
- Conversant at configuring, maintaining log shipping for synchronization of database and designing, implementation and monitoring of comprehensive backup plans and recovery strategies.
- An effective leader with exceptional communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilizing them in a productive manner.
TECHNICAL SKILLS:
RDBMS: Microsoft SQL Server 6.0 / 6.5 / 7 / 2000 / 2005 / 2008 / 2008 R2 / 2012 / 2014 Oracle 8i / 9i / 10g / 11g
O/S: Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 / 2012 / 2012 R2
Language: T - SQL
SQL Server Tools: SSMS, Query Analyzer, Profiler, DTS, SSIS, SSRS, SSAS:
Other Tools: ER Studio, Red Gate SQL Compare 8, SQL Litespeed. BMC Database Automation (BDA), BMC Remedy ITSM, DBAritsan, FogLight, Maximo, IPCenter, Putty, ESM, Perfmon, Repliweb, Avamar, NetBackup, ERWin, Business Objects.
PROFESSIONAL EXPERIENCE:
Confidential, Houston, Texas
Database Administrator
Responsibilities:
- Delivered primary DBA support for 30+ applications supported by Bank of Confidential Corporate and Enterprise Services Technology SQL Server DBA Team.
- Performed on-call duties and responds to fog light alerts.
- Installed SQL Server and upgraded databases from SQL Server 2008 to SQL Server 2012 and SQL Server 2014.
- Established compliance on SQL Server instances with Bank of Confidential security policies.
- Monitored & assisted application development and production support teams by answering SQL Server questions and deploying SQL Server DML and DDL changes.
- Participated in disaster recovery tests by failing over mirrored and transaction log shipped databases.
- Supported SQL server instances for all environments from development through production for over 30 applications installed SQL Server 2008 - 2014 using BMC Database Automation (BDA) tool; upgraded application databases from older versions to newer versions.
- Troubleshot issues identified by application support teams and pro-active monitoring of databases.
Database Administrator
- Involved in providing DBA support to Merrill Lynch Commodities, Inc. for SQL Server, Oracle Databases and primary support 10+ applications using SQL Server databases.
- Delivered DBA support for a 5+ TB application using Oracle. Improved performance of SQL Queries over 90% by using information found in SQL Server DMVs to determine proper indexes to create.
- Designed and implemented SQL Server Failover Cluster, databases and database changes.
- Ensured smooth service pack up gradation to 70+ servers.
- Participated in disaster recovery tests, failing over and back SQL Server database instances using SRDF replication.
Confidential, Houston, Texas
Senior Database Administrator
Responsibilities:
- Managed and monitored performance tuning of SQL Server databases; participated in 24X7 DBA on-call rotation; implemented new databases and changes to existing SQL Server databases.
- Improved monthly process performance time from 60 minutes to less than 10 minutes.
- Provided primary database support to SQL Servers 2000 servers supporting a natural gas financial trading system for Koch Energy Trading, Axia Energy, and Entergy Koch Trading.
- Handled CNC Administrator duties for JDEdwards’ Accounts Payable, Accounts Receivable, and General Ledger applications.
Confidential, Houston, Texas
Senior Database Administrator
Responsibilities:
- Provided SQL Server 6.5 DBA support for the Koch Energy Trading Power Trading Application.
- Detected a data type mismatch in the SQL Server database that, when fixed, reduced time on a particular query from over an hour to under 10 minutes.