We provide IT Staff Augmentation Services!

Sql Server Dba Resume

IL

EXPERIENCE SUMMARY

  • Have been working as an Operational and Development DBA with good experience in Information Technology including Database Administration, Development, Configuration Management, Analysis, Design, testing, Integration and deployment with MS SQL Server 2000/ 2005/2008/2008 R2 and 2012.
  • Experience in setting up the DBA environment, documenting build and deployment processes.
  • Experience in configuring, supporting and troubleshooting high availability solutions such as Log shipping, Database mirroring and Replication topology and Clustering.
  • Experience in the migration and implementation from other databases to MS SQL Server 2000/MS SQL Server 2005/ MS SQL Server 2008/2008R2/MS SQL Server 2012.
  • Experience in designing and setting up new Data warehouse environment in Dev, QA and Prod environment
  • Very strong DBA skills such as backup and disaster recovery, performance monitoring and improvements & daily preventive maintenance of multiple SQL Servers on Windows 2000/2003/2008 Servers
  • Good experience in configuring Reporting (SSRS), Integration (SSIS) using SQL server 2005/2008/2008 R2/2012.
  • Very good experience in installation, upgrades service packs, database migrations, releases on Development, QA and Production Servers.
  • Experience in operational support tasks, developer support and QA support as well as troubleshooting Dev and QA database failures
  • Experience in implementing DBA standards, methods, processes and SOX controls across all servers and databases
  • Deployed database objects from development/testing environment to production environment.
  • Good knowledge of configuration management concepts, release management, changes management concepts, Industry standards and best practices
  • Experienced in Migrating and Tuning T-SQL scripts, indexes, stored procedures and views. Tuning and optimization of SQL queries and stored procedures using SQL Profiler and Performance monitor and ensuring indexes are using updated statistics
  • Experience in providing both On-shore and Offshore development and maintenance throughout the project.
  • A team player with strong leadership skills apart from solid technical and analytical skills.
  • A quick learner that strives for new technical knowledge & ability to communicate with all levels of corporate personnel.
  • Excellent Project Management skills and reporting skills.

TECHNICAL SKILL SET

Database Management System: MS SQL SERVER 2012,MS SQL SERVER 2008R2, MS SQL SERVER 2008, MS SQL SERVER 2005, MSSQL Server 2000, MS-Access

Database Utilities: Enterprise Manager, Query Analyzer, SQL Server, Profiler, SQL Server Management Studio.

ETL tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Analysis Services: MSSQL Server Analysis Services

Reporting Tools: MSSQL Server Reporting Services, Business objects

Programming Language: TSQL, C, C++

Web Technologies: Web Services, MS IIS

Application Packages: MSOffice

Operating Systems: Windows Server 2000/2003/2008 , Windows XP

Other Tools: Red Gate, spot light, VISO, IDERA, SQLSENTRY, QUEST

WORK EXPERIENCE

Confidential, IL

Role: SQL Server DBA

Confidential puts providers on the fast track to better patient outcomes. With the Confidential Registry and other patient-centered technology, Confidential is the system for providers who want to deliver high value in medicine through Accountable Care Organizations (ACO), Clinical Integration, PQRS reporting, and value-based purchasing initiatives. Start with performance measurement to identify gaps in care, and then close them. Help physicians engage patients in a partnership for better outcomes — and a better life.

Responsibilities:

  • Managed and Administrated the SQL Server 2012/2008R2/2008/2005production and Non-production servers.
  • Design and implement comprehensive Backup plan and disaster recovery strategies
  • Installation of SQL Server 2012/SQL2008R2 on Windows Server.
  • Managed multiple database related projects, design, implement and support moderate to large sized databases.
  • Worked closely with the application Team for design and decision-making
  • Worked on hardware capacity planning and database upgrades for the newly built servers.
  • Worked on Stored procedures for building internal applications with Application Team.
  • Troubleshot and coordinated with various technology groups to resolve live production issues.
  • Provide 24x7 Production Database and on-Call Support.
  • Performance tuning of batch scripts, store procedures, and functions using tools such as SQL Profiler/ Analyzer, Performance Counters, and Execution Plan.
  • Participate in the researching solutions to various business and technical problems.
  • Implemented Security using SQL Logins, Roles and Security Modes for various users.
  • Provide project technical status reports

Environment: SQL Server 2012/2008 R2/ 2008/2005, Advanced Windows 2008/03 server, BIDS, SQL Profiler, Perfmon, T-SQL, SSRS, REDGATE.

Confidential, NC

Role: SQL Server DBA

Confidential is one of the nation's leading specialty loan servicing companies. Seterus is a fully integrated loan servicing company consisting of experienced, skilled professionals using leading technology. Customer service is a top priority for Seterus in all interactions that we have with the borrowers we serve.

Responsibilities:

  • Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
  • Design and implement comprehensive Backup plan and disaster recovery strategies
  • Installation of SQL Server 2008 on Windows Server Clustered environment.
  • Setting up and Monitoring Log Shipping and replication on Production, QA and Dev servers.
  • Maintaining and troubleshooting replication and log shipping.
  • Performing review of new enhancements and changes put into database system through releases and deploying them to production environment.
  • Troubleshot and coordinated with various technology groups to resolve live production issues.
  • Performance tuning of batch scripts, store procedures, and functions using tools such as SQL Profiler/ Analyzer, Performance Counters, and Execution Plan.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • Provide 24x7 Production Database and on-Call Support.
  • Provide project technical status reports

Environment: SQL Server 2008R2/08/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, VM ware, REDGATE, LiteSpeed,CA Autosys.

Confidential , MD

Role: SQL Server DBA

Confidential is dedicated to offering healthcare programs and services that help improve the quality of care for Medicare beneficiaries with chronic illnesses. We provide innovative chronic care solutions for Medicare beneficiaries and providers that encourage better management of chronic diseases such as diabetes and heart failure.

Responsibilities:

  • Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
  • Handled up to 2TB of databases.
  • Installation of SQL Server 2008 on Windows Server Clustered environment.
  • Created, deployed and managed reports using SQL Server Reporting Services (SSRS) for Scale-out-deployment.
  • Setting up and Monitoring Log Shipping on Production, QA and Dev servers.
  • Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Experience in providing both On-shore and Offshore support throughout the project.
  • Deployed database objects from development/testing environment to production environment.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • A quick learner that strives for new technical knowledge & ability to communicate with all levels of corporate personnel.
  • Provided 24x7 support for both offshore and onsite teams.

Environment: SQL Server 2008R2/08/05/00, Advanced Windows 2008/03 server, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, VM ware, REDGATE, DBArtisan, spot light.

Confidential , PA

Role: SQL Server DBA

PHLY is a team of motivated, high achievers committed to delivering innovative products and unsurpassed service to niche insurance markets.PHLY operates in 47 offices covering the United States.PHLY continuously reviews and refines our business processes to improve efficiency and the ease of doing business.

Responsibilities:

  • Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
  • Deployed the SQL Packages from development to production environment on day to day basis.
  • Installation of SQL Server 2008/2005 on Windows Server Clustered environment.
  • Provided 24x7 support for both offshore and onsite teams.
  • Setting up and Monitored Database mirroring and Log Shipping on Production, QA and Dev servers.
  • Migrated SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS packages as part of deployment.
  • Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
  • Configured and deployed SSIS Packages from Test to Production Environments.
  • Created, deployed and managed reports using SQL Server Reporting Services (SSRS)
  • Deployed database objects from development/testing environment to production environment.
  • Reviewed stored procedure developed by the developers and given recommendations for the code modifications for production.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.

Environment: SQL Server 2008R2/08/05/00, Advanced Windows 2008/03 server, XML, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, VM ware, Spotlight ,SQLSENTRY.

Confidential

Role: Jr. SQL Server DBA

Confidential is a reputed software consulting group based out of Columbus. It is focused on providing the best quality, cost-effective solutions. We are recognized as a trusted partner to provide Business/Technical resources across a broad range of market segments

Responsibilities:

  • Installed, Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
  • Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases.
  • Recovering the databases from backup in disasters. Created and Monitored Database Maintenance Plans
  • Configured and deployed SSIS Packages from Test to Production Environments
  • Performance tuning of batch scripts, store procedures, and functions using tools such as SQL Profiler/ Analyzer, Performance Counters, and Execution Plan.
  • Managed Security using SQL Logins, Roles and Security Modes for various users
  • Worked with different teams and involved in different projects

Environment: SQL Server 2008R2/08/05/00, Advanced Windows 2008/03 server, XML, VSS, BIDS, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS, VM ware, Spotlight ,Idera

Confidential , VA

Role: Student Assistant

Responsibilities:

  • Responsible for Maintaining the Student database.
  • Updating the database server of the library with new software’s.
  • Created the database for maintaining the student’s record for University.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Managed and Administrated the SQL Server 2005/2000 production and Non-production servers
  • Export or Import data from other data sources like flat files using Import/Export of DTS
  • Recovering the databases from backup in disasters. Created and Monitored Database Maintenance Plans.
  • Refreshed the data from production to the development environment.
  • Handled up to 0.75 TB Size databases.
  • Deployed database objects from development/testing environment to production environment.

Environment: SQL Server 2008/05/00, Advanced Windows 2008/03 server, XML, SQL Profiler, Perfmon, T-SQL, SSIS, SSRS,

Hire Now