Database Administrator Resume Profile

APPLICATION

SOFTWARE

SQL Server 6.5 7.0, Windows Server, Erwin, Word, Excel, Tomcat, Oracle 9i

WORK EXPERIENCE

Database Administrator

Confidential

Acted as production dba for Wholesale Services systems for 30 servers
Maintained backups for Wholesale Services systems
Performed security work for principals and permissions for SQL Server
Participated in deployments for division involving SQL Server code
Performed tier 3 production support for SQL Servers
Performed query optimization including index, query and query plananalysis.
Troubleshot all aspects of SQL Server 2005 administration for test servers during Capt
Migration.
Provided advanced monitoring and tuning skills for SQL Server 2008 using
Performance Monitor, SQL Profiler and extended events
Designed and implemented staging area data structures for migration.
Setup and maintained merge and transactional replication.
Create and migrated DTS packages to SSIS for migration.

Contract Database Developer

Confidential

Developed ELMS system web front end application using Java, Javascript, servlets and jsp pages.
Developed DTS packages for corporate reporting, numerous data feeds using T SQL,
J Script using SQL Server 2000.
Developed, tested and implemented nationwide data feed using T SQL DTS package which feeds office information throughout continental United States.
Optimized queries to run against extreme stresses in production environment.
Designed and implemented test environment.
Used SQL Profiler to analyze and improve performance of T SQL data feed.
Performed system analysis and developed requirements for all projects.
Wrote stored procedures and views using T SQL.
Provided support when necessary for all jobs moved into production.
Created ERD diagrams and performed data modeling of all projects using Erwin.

Datawarehouse Database Administrator

Part of team that designed, coded and implemented Mortgage Manager Application using jsp pages and java servlets
Developed cubes as basis for corporate reporting using SQL OLAP services and provided support for third party reporting tools.
Developed MDX queries.
Provided user support for corporate applications and warehouse reporting.
Participated in database administration, reorganization of server security, produced documentation for compliance for Sarbanes Oxley audit.
Supervised and supported nightly server build process of ETL process.
Created data model of data warehouse and supporting ERD diagrams.

Confidential

Business Control Systems

Installed and configured production SQL Server 7.0 servers, including application of service packs.
Responsible for creating, maintaining and monitoring backups for servers, replication to reporting server.
Set up and administered SQL Server security on servers.
Performed query optimization including index, query and query plan analysis.
Provided capacity planning and recommendations for purchase of production hardware and software configuration.

Database Administrator

Confidential

Designed and implemented mission critical SQL Server 7.0 databases to support the Market Research Call Center in 24/7 environment.
Performed upgrade of company databases from SQL Server 6.5 to SQL Server 7.0.
Performed SQL Server troubleshooting for other groups.
Wrote stored procedures and triggers for all company client server, development.
Created export of time accounting information to parent company using SQL
Server DTS and FTP.

Database Administrator

Confidential

Performed all aspects of database administration for SQL Server 7.0 databases in a 24/7 environment.
Using Transact SQL, developed extensive stored procedures to implement business rules.
Using Transact SQL, developed administration stored procedures to the company's hundreds of databases.

Database Administrator

Confidential

Performed all aspects of database administration for SQL Server 6.5 databases in a 24/7 environment.
Performed SQL Server software upgrade from SQL Server 6.5 to SQL Server 7.0.
Performed database administration supporting major server alterations.
Evaluated software for acquisition.
Provided user support for new and existing applications.
Designed and implemented backup strategy.
Received bonus every year of employment.
Set up automated download and import of mainframe data using SAS.
Set up replication for reporting server.

Database Administrator

Confidential