Senior Lead Database Administrator Resume
3.00/5 (Submit Your Rating)
Washington, DC
OBJECTIVE:
To gain employment with a company or institution that offers me a consistently positive atmosphere to learn new technologies and implement them for the betterment of the business.
SUMMARY:
- Over 20 years’ experience in Information Technology with special focus as a LAN Administrator, Programmer, Recovery Administrator,, Project Manager and Database Administrator/Manager also ample experience in Data Modeling a MS - SQL and Sybase Enterprise Environment
- Diversified business experience as with insurance companies, warehouses, .coms, colleges, non- profit, corporations and the government
- Over 16 years experience in Database Administration, Data Modeling, Database Security and Architectural Design in SQL and Sybase
- Experience in installation of database servers, performance analysis and optimization of large databases, design and maintenance of backup systems and physical disk and capacity planning
- Experience in leading migration and upgrade projects
- Project manger of business continuity projects
- Implemented backup and recovery solutions for databases
- Implement Clustering and virtualization
- Developed T-SQL stored procedures and user defined scripts to handle business functions and database maintenance
- Professional experience in data modeling using ER-Win and Microsoft Visio
WORK HISTORY:
Confidential, Washington, DC
Senior Lead Database Administrator
Responsibilities:
- Provides standards and procedures and for monitoring, capacity planning, maintenance backups and disaster recovery
- Provides support to multiple databases in development, test and production phases
- Designs, configures, installs, creates and refreshes databases for MS SQL 2000, 2005, and 2008, 2012, 2014, 2016
- Applies patches, updates and sets up merge replications
- Moves databases and applications to new servers when needed
- Performs database tuning which optimizes data performance by analyzing objects generating statistics, and creates indexes and views
- Creates scripts to automate database maintenance procedures and to generate system reports using SSIS
- Leader of database upgrade and migration projects
- Architect of database systems for availability in clusters, replication, mirroring or a combination of both. Including Table portioning as needed.
- Provides on call support 12/7 weekdays and 24/7 weekend rotation to MS SQL databases
- Mentor and supervises of Jr. Database Administrator
- Designs architecture to involve SQL clusters and replication.
- Upgrades SQL 2000 to up SQL 2016
- Installs, configures and maintains a up to SQL 20016 cluster
- Met SOX compliancy
- Configures and installs Reporting Services as needed
- Works on Global team supporting SQL servers World Wide
- Managed team of 2
- Designs, configures and implements backup and recovery solutions for Databases
- Implemented and configured Database Security
Confidential, Washington, DC
Database Administrator/Project Manger
Responsibilities:
- Set up and maintained production servers for the enterprise and created as well as implemented a policy for those servers
- Created and implemented a development environment using Virtual Server
- Led and managed the upgrade of Navision for the finance division and migrated the data into the HR Cort system
- Implemented database for SharePoint
- Upgraded and moved databases and applications to new servers
- Project manager for disaster recovery and the corporate backup system
- Member of corporate BCP Plan
- Supervised the IT disaster recovery team
- Tuned all databases
- Recommended and implemented SQL Sentry to monitor all jobs on the SQL server
- Worked with the Network Engineers in redesigning the corporate network
- Supported helpdesk staff
- Managed software licensing
- Acted as temporary operations manager for 6 months
- Implemented and configured database security
Confidential, Washington, DC
Database Administrator / Enterprise Recovery Administrator
Responsibilities:
- Setup and maintained 25 Microsoft SQL server databases 20 of which were production servers
- Supervised one Junior SQL administrator
- Setup and maintained Sybase Adaptive server off site
- Maintained 1 Oracle database
- Tuned all databases and assisted with queries
- Moved databases and applications to new servers
- Installed and configured servers
- Wrote scripts to automate the MS SQL Server
- Backup Administrator
- Helped out on RS6000 and AS400
- Integrated software for PVCS, Heat, Ceridian Web Sense and other Apps
- Upgraded SQL 6.5 to 7.0 to SQL 2000
- Project Leader in implementing Veritas Net backup as an enterprise solution for backups
- Project Leader for disaster recovery
- Developed DTS packages
- Configured SQL mail on all production server database diagrams
- Met HIPA compliancy