Senior Sql Server Dba Resume
Mclean, VA
SUMMARY
- Senior MS SQL Server Database Administrator with Eight+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments
- Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R2/2008/2005 in VIRTUAL and PHYSICAL environments.
- 4+ Years experience in Upgrade of SQL Server from lower version to higher version
- Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering
- Experience in Setting up AlwaysON availability groups on 2012
- Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
- Provided 24/7 and On - call Support for PRODUCTION environment
- Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
- Extensive use of PowerShell Scripting.
- Expert in working with SAN boxes from EMC, configured RAID 0,1,5
- Expertise in VMWARE and managing multiple SQL Server Instances on Physical and VMWARE
- Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE replication
- Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups
- Used third party tools like Redgate, SQL Litespeed and Netbackup for Backups
- Used IDERA, FOGLIGHT and SQL Sentry for Monitoring and Performance tuning
- Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2
- Expert in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD
- Extensive use of SQL Server DMV's for Performance Tuning.
- 5+ years experience in SSIS/SSRS
- Created heavy duty SSIS packages and deployed the packages from development to different environments
- Worked heavily on SSIS transformations and layed out strong SSIS packages
- Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.
- Performed Capacity Planning, Data Modeling and Logical/Physical database design.
- Performed Logical/Physical Modeling and Reverse engineering with ERWIN and VISIO
- Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
- Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
- Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
- Experience in resolving Database Performance, Capacity and Distributed data issues.
- Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.
- Created extensive reports using SSRS ( Tabular, Matrix)
- Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Data Warehouse concepts.
TECHNICAL SKILLS
Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000
Operating Systems: Windows 2012/2008 R2/2003, VMware, Microsoft Azure
ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS
Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry, VSS
Data Modeling Tools: Erwin, Microsoft Visio
SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers
PROFESSIONAL EXPERIENCE
Confidential, McLean, VA
Senior SQL Server DBA
Responsibilities:
- Implemented new 2014 SQL Servers in Production and Dev environments
- Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2
- Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
- Migrated SQL Server from SQL Server 2008R /2014
- Managed OLTP, DSS applications/databases in Physical and Virtual Environment
- Worked extensively on Virtual and VMware Environments.
- Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
- Involved in Performance Tuning on Production, QA and Staging servers of the current project.
- Managed Production environment for High Availability in Active/Active and Active/Passive mode
- Worked on AlwaysOn availability groups and replicas for reporting, backup and performance
- Installing and Configuring SQL Server 2014/2012 AlwaysON availability groups for high availability
- Involved in Monitoring Performance of different production servers.
- Worked on PowerShell Scripting
- Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
- Planning the location of data, index and Transaction log files on the disk.
- Performance tuning and optimization of procedures and queries.
- Extensive use of SQL Server DMV's for Performance Tuning.
- Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks.
- Created the backup and restore strategy for production and development environment.
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
- Worked on creating SSAS cubes and laying out SSAS designs
- Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
- Created extensive SQL Server Integration Services (SSIS) packages for ETL. created database logical/physical modeling with ERWIN
- Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
- Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
- Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
- Created Linked Servers for data retrieval using OLE DB data sources and providers.
Environment: SQL Server 2014/2012/2008 R2, VMware, Virtualization, AlwaysOn SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2012, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager
Confidential, Pittsburg, PA
Senior SQL Server DBA/Developer
Responsibilities:
- Managing Production SQL Servers on VIRTUAL and PHYSICAL environments
- Installing and Configuring SQL Server 2005/2008/2008 R2/2012.
- Supporting the business 24/7, maintaining 99.999 uptimes depending on the application and business SLA requirements.
- Involved in upgrading SQL Server 2005 instances to SQL Server 2008 R2
- Involved in database design, database standards, T-SQL code reviews.
- Configured Active/Active and Active/passive SQL Server Clusters.
- Implemented Mirroring and Log Shipping for Disaster recovery
- Planned and Implemented complete backup strategy for Full, Differential and Log Backups
- Created extensive SSIS packages, deployed them to various servers and scheduled them for execution
- Configured transactional and snapshot replication and managed publications, articles.
- Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level.
- Maintained database response times and proactively generated performance reports.
- Automated most of the DBA Tasks and monitoring stats.
- Responsible for SQL Server Edition upgrades and SQL Server patch management.
- Created a mirrored database for reporting using Database Mirroring with high performance mode.
- Involved in data modeling for the application and created ER diagrams using Erwin and VISIO.
- Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
- Trouble shooting and supporting all user problems by using SQL server profiler, network traces, Windows logs etc.
- Migrated DTS Packages to SSIS Package.
- Monitored event and server error logs for troubleshooting.
Environment: MS SQL server 2005/2008 R2/2012, Windows 2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS, SSRS, Erwin, VISIO.
Confidential, Bethesda, MD
SQL Server DBA
Responsibilities:
- Installed SQL Server 2008 in production, test and development environments.
- Managed servers in Clustered, Mirrored and Log Shipping environment
- Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems
- Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
- Designed and implemented database changes.
- Reviewed and tune up SQL queries, stored procedures, views and triggers.
- Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
- Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
- Managed health of SQL Servers including backups, restores and monitoring.
- Provide a working model of transaction processing environment for capacity assessment and planning.
- Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
- Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
- Provided technical support during the development, design enhancement and implementation of production databases.
- Worked with the transaction processing area to develop both the physical and the logical database administration functions.
- Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
- Worked with vendors in evaluating and implementing new technologies.
Environment: MSSQL Server 2005 and 2008, MS Windows Server 2003, 2008, SSIS, SSRS.
Confidential, Fort Worth, TX
SQL Server DBA
Responsibilities:
- Responsible for Query optimization and Performance tuning.
- Rebuilding of indexes to improve data retrieval performance
- Managed Microsoft Clustered SQL Server 2000 and 2005 environments.
- Involved in Migration from SQL 2000 to SQL 2005.
- Managing server logins, database users and permissions.
- Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
- Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
- Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
- Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
- Configuration and Administration of IIS 6.0, Windows 2003 server.
- Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
- Managing security tasks like granting and revoking permissions
Environment: Windows Server 2000/2003, VMware, SQL Server 2005, Windows 2003, DTS, T-SQL.
Confidential
SQL Server DBA
Responsibilities:
- Database Administration for Development, Test and Production servers with MS SQL Server 2005 on Windows 2000/2003.
- Administered MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring user accounts, creation of groups, granting the privileges to users and groups.
- Created DTS package to export and import data from SQL Server to Access, text and excel files.
- Checked performance tuning, indexing and query optimization.
- Used database consistency checks using DBCC utilities.
- Implemented Snapshot Replication and Transactional Replication.
- Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.
- Created Linked Servers for data retrieval using OLE DB data sources and providers.
Environment: Windows Server 2000/2003, MS SQL Server 2005/2000, XML and Erwin.
Confidential
SQL Server DBA
Responsibilities:
- Database Administration for Development, Test and Production servers with MS SQL Server 2000/2005 on Windows 2000/2003.
- Created backups for databases.
- Involved in Performance tuning.
- Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system with ERWIN.
- Gathered requirements from business users.
- Wrote user requirement documents based on functional specification.
- Designed physical data models.
- Created functions, views and triggers.
- Developed source to target specifications.
- Created DTS package and schedule the jobs for batch processing.
- Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it
Environment: Windows Server 2000/2003, MS SQL Server 2005, 2000 and Erwin, Stored Procedure, Views, Triggers.