Sr. Sql Server Dba Resume
Southlake, TX
SUMMARY
- Over 9 years of experience in IT in Database Administration and Developer for very large and complex databases in SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Worked on SQL Server 2008R2 Migration from SQL Server .
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
- Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
- Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
- Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
- Having hands on experience in DR processes including AlwaysOn, Log shipping and Database Mirroring.
- Troubleshoot performance problems, fine - tuning of databases and index Analysis.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Worked on configuring SQL Server with minimum privileged access.
- Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
- Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
- Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
- Having Experience on Data center servers and handling 22 TB databases.
- Experience in using tools like SQL Sentry, SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
- Working knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert.
- Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
- Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
- Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS).
- Implemented different types of Replication models like Transactional and Snapshot
- Strong experience in mentoring team members and writing documentation.
- 24 X 7 Production Database on Call Support
- Worked on importing data from MySQL to SQL Server.
- Expertise in T-SQL writing stored procedures, triggers and functions.
- Worked on logical and physical data base modeling with UML and ERWIN tools
- Worked on Sales Force, Jira, BMC Remedy, Resolve, Virtual Ticket & Service Now ticketing system software’s.
TECHNICAL SKILLS
Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, 2000
Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL
DBA: database administration of SQL Server 2012, 2008R2, 2008, 2005, 2000
Operating System: Windows 2008/2003/2000 Advanced Server, NT & Windows 9x, Linux
Tools: SQL Sentry, Backup Utility, SQL LiteSpeed, MS Visio
PROFESSIONAL EXPERIENCE
Confidential, Southlake, TX
Sr. SQL Server DBA
Responsibilities:
- Analyzing the Database Infrastructure / servers / storage and provide technical recommendations for improving the SLA times with business users and implement optimization changes for better performance for applications.
- Migrated SQL2008 applications to SQL2014 with Always on high availability clusters for disaster recovery and reporting.
- Implementation of Replication Models (for OLTP Servers) using Merge and Transactional (with updatable subscriber) on large terabyte databases.
- Involved in Fine Tuning and Performance and Query optimization of the Database as required by the application.
- Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size.
- Implemented 2 way Replication (Pub-Pub) between 1 Publisher and 3 Subscribers.
- Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
- Implementing the Security strategy for each environment and the required backup strategy as well.
- Use DMVs and custom scripts to tune performance of SQL Server queries.
- Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
- 24 X 7 On-call support rotation for SQL Server database systems, products and services.
- Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
- Develop and deploy trace files to audit DBA activities, DDL commands and Security events in SQL Server. Automate the process of reporting unauthorized activities.
- Design and develop database backup and recovery procedures.
Environment: MS SQL Server 2014/2012/2008 R2/2008, SQL Lite Speed, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, SSRS, SSIS, BCP and Microsoft Cluster.
Confidential, Irving, TX
Sr. SQL Server DBA
Responsibilities:
- Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
- Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring and Log Shipping to provide multiple copies of production data that can be used for disaster recoveries.
- Set up Log shipping between Primary Server (PROD) & Secondary Server (COB).
- Worked on Cob tests during weekends to test COB environment by business users.
- Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
- Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment
- Extensively worked on auditing entire environment by building SQLMonitoring database to capture everything single thing in the prod environment.
- Deploying new code base release to UAT and Production Environments.
- Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
- Provide expertise for using best RAID Technologies based on application requirement.
- Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
- Extensively used Service Now tool for any changes in the environment and also incidents.
- Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
- Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.
- Used SSIS to move auditing files from SQL server to Unix server.
Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.
Confidential, Plano, TX
SQL Server DBA
Responsibilities:
- Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
- Responsible for overall database environment and maintain operational uptime of 99.9%.
- Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
- Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism.
- Designing, Implementing and administering the transactional replication from Primary database server to the 6 search pool servers.
- Setup SQL Mail and integrate it with the application, design and manage replication.
- Install and configure SQL LiteSpeed for SQL Server to backup SQL Server database or setup database maintenance plan to back up all the databases locally on the disk.
- Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
- Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
- Monitoring the servers usingIdera third party software and backups using SQL Litespeed.
- Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
- Deployed SSIS packages and worked on Reporting services.
- Created logins and Roles with appropriate permissions for temporary and permanent access requests.
- Scheduling the Backups and performing the restoration. Support for huge Databases.
- Provided 24/7 on-call support on rotation basis for production database.
Environment: MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.
Confidential, Irving, TX
SQL Server DBA
Responsibilities:
- Upgraded SQL Server R2 and SQL Server in Microsoft Windows Server 2008 R2 Enterprise Edition.
- Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
- Performed Backups and restores on regular basis for Migration and other purposes.
- Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
- Use custom developed scripts to identify missing indexes.
- Worked with tickets like RFC’s for prod/UAT changes and VT’s for QA/DEV servers.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
- Used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
- Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates.
- Database refreshes from prod to stage, test and development environments.
- Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
- Production and on call support on rotation basis.
- Solved issues related to server performance and disk space.
- Rebuilding the indexes at regular intervals for better performance.
Environment: MS SQL Server 2008R 2/2008/2005/2000 , Visual Studio 2010/2005, SQL Lite Speed, Microsoft Visio 2003, SFTP and Windows Server 2003/2000.
Confidential, Coppell, TX
SQL Server DBA
Responsibilities:
- Installed and configured SQL Server 2005 and 2008R2 in production and development environment.
- Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
- Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005/2008.
- Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
- Expertise in designing databases and capacity planning.
- Created jobs, alerts, activity logs, error logs to capture any possible errors.
- Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
- Monitored and modified Performance using execution plans and Index tuning.
- Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
- Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
- Creating documentation for error resolving fixtures.
- Worked with Jira ticketing system software to solve issues.
Environment: Microsoft Windows Server 20 /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed.
Confidential, Dayton, OH
SQL Server DBA
Responsibilities:
- Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
- Database Administrator, Database Programming.
- Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Configured transactional Replication from multiple subscribers for reporting purpose.
- Deploying new code base release to UAT and Production Environments.
- Working with customers on Application rollouts and server migrations.
- Extensively worked on DBCC commands and Dynamic Management Objects.
- Worked with change management and change control procedure.
- Converting DTS packages into SQL Server 2005 Integration Services
- Solved issues related to server performance and disk space.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- Support Development team in deploying and testing the application.
Environment: Microsoft Windows Server 2000/ /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.
Confidential
SQL Server DBA/Developer
Responsibilities:
- Perform business analysis, technical analysis, systems design, application software programming.
- Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
- Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
- Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases .
- Rebuilding the indexes at regular intervals for better performance.
- Manage replication and database modifications for replicated objects.
- Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
- Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
- Design, document and implement SSIS packages and stored procedures.
- Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Support and troubleshoot as required, optimize performance and resolve production problems.
- Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
- Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
Environment: Windows 2003 Server, SQL server 2005/2000, Event Viewer, SQL Profiler, T-SQL.
