Senior Database Administrator Resume
SUMMARY
- Detail - oriented Information Technology professional with excellent Database Administration and Network experience, coupled with strong organizational, problem solving and planning skills.
- Efficient team player, that learns quickly, works hard and has strong analytical skills.
PROFESSIONAL EXPERIENCE
Confidential
Senior Database Administrator
Responsibilities:
- Perform daily health checks on enterprise wide SQL Servers in AWS EC2
- Architect and build SQL Server instances in AWS EC2
- Review SQL Server instances and standardize for optimal performance
- Implemented SolarWinds DPA for performance monitoring and alerting
- Create SQL Server Documentation and Standard Operating Procedures
- Perform Code Reviews and provide recommendations for performance improvements
Confidential
Senior Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Investigated SQL Server monitoring and alerts and provide analysis on improvements
- Reviewed SQL Server Performance and provide Tuning recommendations on company databases
- Engaged and researched Red Gate SQL Monitor for alerts and performance monitoring on SQL Server
- Provide mentoring to team members through training and documentation
Confidential
Senior Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Architected and built SQL Server instances in AWS EC2
- Standardized SQL Server instance builds
- Reviewed performance and provided recommendations for SQL Server databases
- Implemented SQLSentry for performance monitoring and created alerts for SQL Server
- Reviewed and updated Database Administration Standard Operating Procedures
- Performed Code reviews and deploy database releases as part of SDLC cycle
Confidential
Senior Database Architect
Responsibilities:
- Provided Database Administration Support for SQL Server
- Implemented and Ensure High availability for SQL Server using AlwaysOn
- Implemented SQL Server Monitoring using Idera Diagnostic Manager
- Created Database Administration Standard Operating Procedures
- Investigated and Implemented Database Backup and Restore tasks
- Automated Nightly and Weekly Maintenance tasks
Confidential
Enterprise MSSQL Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Implemented and Ensure High availability for SQL Server using AlwaysOn
- Provided Performance Tuning analysis on company databases
- Engaged with Dynamics AX developers for reviewing SQL Server performance
- Implemented monitoring procedures for DynamicsAX databases on SQL Server
Confidential
Database Architect
Responsibilities:
- Provided Database Administration Support for SQL Server
- Managed and provided Technical leadership for various SQL Server projects
- Performed troubleshooting, administration and deployments of SSIS packages
- Researched, Analyzed and updated Database Administration Standard Operating Procedure documents
- Engaged with Business units to discuss needs and requirements for SQL Server database performance
- Provided leadership and mentoring to offshore database team
- Ensured High Availability using Clusters, Database Mirroring, Log Shipping and Replication
- Provided Performance Tuning analysis and recommendations
- Researched and recommended improvements for SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014
Confidential
Senior Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Provided Administrative and Troubleshooting Support for Business Objects
- Provided mapping details for MYSQL databases between Confidential and Ticketmaster
- Implemented ETL process to load data from MYSQL databases from Ticketmaster into Confidential
- Ensured High availability using Clusters, Database Mirroring, Log Shipping and Replication
- Provided Performance Tuning analysis
- Researched and recommended improvements for SQL Server 2005 and SQL Server 2008
- Researched and evaluated SQL Server 2008 for Enterprise wide upgrades
Confidential
Database Specialist
Responsibilities:
- Provided Database Administration Support for SQL Server
- Provided leadership and mentoring to Offshore Database team
- Managed Database Releases
- Performed in-place and parallel upgrades from SQL Server 2000 to SQL Server 2005
- Configured, troubleshoot and monitored replication
- Troubleshoot and Implemented SSIS packages as needed
- Performed Code review for developers and recommend changes as needed
- Implemented Policies and Procedures to ensure database and code integrity on Enterprise SQL Servers
- Researched and recommended improvements to SQL Server 2005 to ensure high availability
- Researched and evaluated SQL Server 2008 for Enterprise wide upgrades
Confidential
Senior Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Managed Database Support for Releases to Enterprise SQL Server 2005 Databases
- Implemented and Configured SQL Server 2005 Standalone and Clusters
- Provided daily administration and operation support for enterprise Production SQL Servers
- Troubleshoot and Implemented SSIS packages as needed
- Performed Code review for developers and recommend changes as needed
- Implemented Policies and Procedures to ensure database and code integrity on Enterprise SQL Servers
- Researched and recommended improvements to SQL Server 2005 to ensure high availability
Confidential
Technical Architect - Enterprise Database Support
Responsibilities:
- Provided Database Administration Support for SQL Server
- Managed Database Support for Releases to SQL Server Databases
- Implemented and Configured SQL Server Standalone and Clusters
- Imported and Exported data from company databases using DTS packages
- Performed research for database errors and provide resolutions
Confidential
Lead Database Administrator
Responsibilities:
- Created and Assigned tasks to Database Administration team
- Provided Database Administration Support for SQL Server
- Implemented and Configured SQL Server Clusters in Disaster Recovery Site.
- Performed SQL Servers upgrades to current service packs and Cumulative Updates.
- Imported and Exported data from company databases using DTS packages.
- Performed daily health checks on CPU, memory and space usage.
- Created DTS packages to perform data processing.
Confidential
Database Administrator
Responsibilities:
- Provided Database Administration Support for SQL Server
- Optimized Month End processing using DTS packages that moves data into historical databases
- Created Master Lookup solution that helped to retrieve customer information for marketing campaign
- Created processes and databases for customer mass mailing to conform to the Privacy Act
- Created, update and run stored procedures and batch files for various tasks on databases
- Created and executed queries to analyze and compare data and columns
- Created Data Layout files to import and export data
