Sql Server Dba Migration Lead Resume
SUMMARY:
A hands - on technology professional with proven skills that cover a variety of data driven applications and environments. Noted as an educator, manager, team builder and administrator, and gifted with an innate ability to understand processes and functions.
AREAS OF EXPERIENCE INCLUDE:
- Database Administration
- SQL Server 2014/2012/2008 R2/2005
- Database Development and Query Tuning
- SQL Server 2008R2/2008/2005
- Business Intelligence Development
- SQL Server 2012/2008R2/2008/
- Application Development
- Design Platforms: VS 2013/2012/2008/
- Infrastructure Administration
- Database troubleshooting and maintenance
- T-SQL Queries
- ETL - SSIS/DTS
- TFS
- Win Server 2008/2003/2000/ NT4
- Database Migrations, ETL deployments, 3rd party technologies
- Stored Procedures
- MS Analysis Services Administration
PROFESSIONAL EXPERIENCE:
Confidential
SQL Server DBA Migration Lead
Responsibilities:
- Lead DBA for an Enterprise migration project, that will migrate this Client’s Data Center from its current environment to a secured cloud environment.
- Responsible for the architecture and implementation, including migration of all databases, SQL jobs, logins and support files.
- Designing new architecture to take advantage of HA technologies of SQL Server 2014, and apply them to a DR environment.
- Handle daily DBA tasks, as well as troubleshooting of complex support issues.
- Provide DBA support for new Data Warehousing and Report design efforts.
Confidential, Dallas, Texas
Database Administrator
Responsibilities:
- Rebuilding the daily monitoring and administration of key database administrative maintenance functions, including insuring backup and maintenance job reliability.
- Handled the upgrading, patching and troubleshooting of the PDW APS, as well as user access and creation of new databases, schemas and deployments.
- Building and maintenance of SQL Server Transactional Replication architectures in new environments, as well as the maintenance and tuning of existing environments.
- Leading DBA Team efforts in a future Disaster\Recovery exercise, that will utilize SQL Server Mirroring and Oracle’s Golden Gate.
- Query and Performance Tuning of In-house developed tsql code using both native SQL Server tools and 3rd party tools
- Create and deploy TSql scripts for database administration support.
- Work with 3rd party monitoring and tuning tools including RedGate and Solar Winds.
- DBA Team “Go To” resource for advanced troubleshooting, database migration, patching and deployment planning.
Confidential, Plano, Texas
Database Administrator
Responsibilities:
- Database lead in migrating 3 production efforts from non-clustered to clustered SQL Server environments. Migrated objects included hundreds of SQL Server databases, as well as replication instances, SQL jobs, SSIS Packages, SQL and AD logins and linked servers.
- Managed the SQL Patching efforts including successful patching of SQL Server 2005, 2008 and 2008R2 in both production and non-production environments.
- Handle all aspects of DBA support for over 230 SQL Server Production Instances and 26 SQL clusters, distributed over 3 data centers.
- Write, deploy and troubleshoot TSQL programming scripts in a production environment.
- SSIS development, deployment and troubleshooting.
- Routinely handle critical and time sensitive database related issues, requiring advanced troubleshooting skills applied to cluster management, SSIS packages, query tuning, disk space issues, database reconfigurations, and security access.
Confidential, Richardson, Texas
Database Administrator Analyst
Responsibilities:
- Migrating ETL processes away from Pervasive 9.02 to SSIS 2008 R2.
- SAP Replat migration from Oracle 10G to SQL Server 2008 R2
- Development and production implementation of Confidential BI Environment on HP Fast Track server.
- Migration of Confidential FocalPoint production from 32 bit to 64 bit environment. Included migration of all databases, objects and security accounts.
Confidential, Dallas, Texas
Instructor/Mentor
Responsibilities:
- Honored with Technical Instructor of the Month three times for excellence in classroom presentation and on line coaching.
- Recognized by Corporate New Horizons for training excellence.
- Received numerous written expressions of training excellence from clients and students.
- Designed and implemented demonstrations and virtualizations, as opposed to the standard Microsoft examples. Notable skills in adopting the curriculum to meet industry-specific needs.
- Provide consistent follow-up to feedback concerning student issues and needs and seek continuous improvement throughout the course and year.
Confidential, Dallas, Texas
Microsoft SQL and Development Mentor
Responsibilities:
- Delivered Independent provider coursework in Visual Studio .Net 2005 as follows: C# and Visual Basic.Net languages; ASP.Net, ADO.Net and T-SQL.
- Evaluated curriculum delivery for SQL Server and .Net development.
Confidential, Dallas, Texas
Senior Dallas / Fort Worth Mentor
Responsibilities:
- Provided the internal leadership that resulted in the DFW facilities top ranking for students and revenue in a 30 location network.
- Selected as Mentor of the Year in 2004.
- Directed a high intensity course to preserve CompUCom’s Microsoft Gold Status
- Key closer in the sales process for complex selling situations.
- Approved curriculum standards and assisted in designing the course work to meet stringent third party standards.