Sql Server Dba Resume
North Canton, OhiO
SUMMARY
- SQL Server DBA with 6 years of experience in SQL Server administration, Implementation and support. Hands - on experience in supporting SQL Servers ‘ 2000/2005/2008/2008 R 2/2012/2014/2016 ’ in investment banking, media, pharmaceutical, market research, and education industries. Offers solid track record based on professionalism, thoroughness, and dedication.
- Able to work both independently and as a team player. Excellent communication, presentation and interpersonal skills.
- Expertise on Production Server with Server Configuration, patch, upgrade, maintain complex and huge databases,and apply encryption to sensitive data and migration experience.
- Experience in Disaster Recovery Planning and Security Management operations.
- Experience in HA Solution such as (WSFC) Cluster, Always ON, Replication, Mirroring and Log Shipping.
- Troubleshoot performance problems, fine-tuning of databases and index Analysis.
- Maintained individual service accounts for SQL Server Services on cluster.
- Migrated data between the two environments with SSIS and Import, Export wizard.
- Experience in working in team as well as individual and writing documentation.
- Designed data Partitioning solutions for tables and indexes & Risk Monitoring and control.
- Experience to work with Development Team closely.
- Created jobs, Alerts, Maintained plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.
- Implemented various Replication Models such as p2p, Merge, Transactional and Snapshot on basis of business specification.
- Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
- Experience in using Performance Monitor, SQL Profiler and optimized queries, traced long running queries and deadlocks.
- Experience in SQL Scripting and automation in Test, Development and Production Server.
TECHNICAL SKILLS
Languages: T-SQL, POWER SHELL, HTMLETL Tools SSIS and Remedy MDM.
Data Model: Darwin 2.0, Erwin, and SSAS.
Reporting Tools: SSRS,Crystal Report and Dimond Report.
Backup Software: SQL Backup, FTP, EMC, TDP and TSM.
RDBMS & Tools: SQL Server 2000/2005/2008/2008 r2 and 2012, 2014, MS Access 2003/2007/2010 , SQL Loader and Export/Import.
Operating System: Windows NT/ 2000/2003/2008 and 2008r2 /2012servers.
Third Party Tools: Red Gate, Spotlight, SCOM and IDERA.
Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETLSQL Server Management Studio and Enterprise Manager.
PROFESSIONAL EXPERIENCE
SQL Server DBA
Confidential, North Canton, OHIO
Responsibilities:
- Install and configure SQL Server Troubleshooting Performance issues and database issues.
- Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
- Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
- Maintain the database consistency by checking with DBCC Utilities at regular intervals.
- Maintain Active/ passive cluster environment with Virtual Machines .
- Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
- Implementing always on in Test environments.
- Maintain and troubleshoot P2P Replication.
- Used DMVS, DMFS, and SP PROCS for the instant analysis.
- Maintain and Manage Security related issues like assign permissions and disable users.
- Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Implemented partitioning for both tables and Indexes.
- Used Online Indexing and online Restoring in SQL Server 2008R2.
- Applied changes on Production through Change Review management after thoroughly testing on development servers.
- Successfully negotiated significant cost reductions with various vendors and utilities.
- Experience in migration of databases from SQL Server 2012 to SQL Server 2014 and 2008R2to 2014.
- Created Security audit for instance level and database level .
- Used encryption for taking backup of sensitive data.
- Installed, authored, and managed reports using SQL Server 2008 R2Reporting Services (SSRS).
- Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).
- Create documentation for steps that need to be taken while upgrading the SQL server 2008R2 to SQL Server 2012.
- Maintain and manage SQL Server Agent Jobs which also included SSIS and ETL process.
- Migration experience in test environments. Also have experience in migration from Sql Server to different platform and vice-versa.
Environment: MS SQL Server 2014/2012/2008 R2,Windows Clustering, Replication, Windows Server 2008R2, .Net Framework, C#.Net, Java8 Update60, MS TFS, MS-Access, SharePoint 2010, Oracle 10g,SCOM,Notepad++,Microsoft Visual C++2013,VNC Server5.3.2,Adobe Flash Player 27 NPAPI
SQL Server DBA
Confidential - Harrisburg, PA
Responsibilities:
- Install and configure SQL Server Troubleshooting Performance issues and database issues.
- Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
- Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
- Maintain the database consistency by checking with DBCC Utilities at regular intervals.
- Maintain Active/ passive and Active/ Active cluster environment with Virtual Machines using Hyper V.
- Create and maintain Transactional, and Peer to Peer Replication environments.
- Implement Database mirroring. Configured Principal, witness and mirror on the 2008R2 SQL Servers.
- Used DMVS, DMFS, and SP PROCS for the instant analysis.
- Implement Asynchronous mode for Database mirroring in Staging Environment.
- Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Implemented partitioning for both tables and Indexes.
- Used Online Indexing and online Restoring in SQL Server 2008.
- Applied changes on Production through Change management after thoroughly testing on development servers.
- Successfully negotiated significant cost reductions with various vendors and utilities.
- Experience in migration of databases from SQL Server 2012 to SQL Server 2014.
- Involved in normalization of the Database in OLTP.
- Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).
- Created SSIS packages to extract data from OLTP sources like MS SQL Server 2012, Text Files, Excel and Access to OLAP systems (SQL Server 2012).
- Create documentation for steps that need to be taken while upgrading the SQL server 2008R2 to SQL Server 2012.
- Migration experience in test environments. Also have experience in migration from Sql Server to different platform and vice-versa.
Environment: MS SQL Server 2012/2008R2/2005,Windows Clustering, Replication, Windows Server 2008R2 and Windows Server 2003, .Net Framework, C#.Net, JavaScript, MS TFS, MS-Access, SharePoint 2010, Oracle 10g, LiteSpeed.
SQL Server DBA
Confidential, Virginia
Responsibilities:
- Migration of databases from SQL Server 2008R2 to SQL Server 2012.
- Installed SQL Server 2012 and configured Always ON with Primary and secondary Replicas, Read only databases, listener and with Application Intent.
- Configured, tuned and maintained SQL server database servers.
- Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects.
- Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
- Deployed and uploaded the SSRS reports to Report Manager for the end users and involved in enhancements and modifications.
- Monitored and modified Performance using execution plans with query hints and Index tuning.
- Performance tuning of existing procedures and packages.
- Creating views and basic stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
- Daily optimization tuning of a Bank Risk Management System including index tuning and query rewrites to apportion system resources
- This project required extensive review and rewrite of stored procedures/ triggers, maintenance plans, troubleshooting SQL servers with enormous databases and implementation of Replication.
- Performed horizontal data partitioning for efficient management of database tables and indexes.
- Working on Client/Server tools like SSMS, SQL Server Enterprise Manager and Query Analyser to Administer SQL Server.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
- Working on different environments and a key resource for deployment of modified objects to production environments.
- Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
- Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
- Incremental loading of dimensions, facts, error handling in SSIS.
- Created Dynamic SSIS packages, to load Stage tables from text files.
- Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
- Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
- Configured and managed virtual Servers and worked on virtualization and clustering environment.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
- Technical Analysis, Code Review, Implementation, 24 x 7 production support.
- Participated in IS Department and production meetings sharing knowledge for the development of the project.
- Environment: MS SQL Server 2005, 2008 R2, 2012, Windows server 2003, 2008 R2, SAN, Visual Studio, DTS packages, SSIS packages, SSRS, Profiler, Index Tuning Wizard, ASP.Net Crystal Reports.
Environment: SQL Server /2008 R2 and 2012R2, SharePoint2007/2010, Windows Server 2003/2008 and 2012. T-SQL, Windows Server /2008 R2 / 2012, .NET, Visual Studio, VMware Virtualization
SQL Server DBA
Confidential, Raritan, NJ
Responsibilities:
- Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1TB.
- Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2.
- Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
- Transferred data from various data sources systems including MS Excel, MS Access, and flat files to SQL Server using SSIS. Created SSIS packages and scheduled the jobs to run automatically.
- Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
- Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
- Performed daily backups and developed recovery procedures.
- Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
- Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
- Implemented and configured database monitoring tools and focused on providing a high availability database.
- Troubleshot issues with log file full and database size increasing Confidential threshold.
- Creation of new database, planning the location of data, index, and transaction log files on the disks.
- Involved in web services SOAP and ODATA.
- Involved in Capacity Planning, data modeling and Logical/Physical database Design
- Handled the database components of application releases .
- Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
- Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
- Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
- Leadership skills to build and guide Infrastructure and production support teams. Experience in working with global teams in onshore/offshore model.
- Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
- Working experience HA solution like Logshipping,Mirroring,Transactional Replication,snapshot replication.
Environment: SQL Server / 2008 R / 2000, T-SQL, Windows Server /2008 R2 / 2012, .NET, Visual Studio, VMware Virtualization.
