We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)

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.

We'd love your feedback!