Sql Server Dba Resume
Alpharetta, GA
SUMMARY
- Around 8 years of IT Experience of SQL server Database Administration for very large and complex databases in SQL Server 2000/2005/2008 R2/2012/2014
- Experience in installing & configuring MS SQL SERVER 2000/2005/2008 R2/2012/2014 on VMWare/Hyper - V environment and updating with hot fix and service packs
- Experience in Data Migration Management
- Migration from SQL server 2000, 2005 and R2 and 2012 by using side-by-side upgrade process, And documented the upgrade Process and also expert in migrating DTS packages to SSIS Packages.
- Used the FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS.
- Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Batches, Stored Procedures, Functions, Cursors, Triggers and other SQL joins and query writing using T- SQL statements.
- Good at SQL Server 2008 features like Policy Based Management, Data Compression, Resource Governor and Transparent Data Encryption (TDE)
- Experience in SQL 2012 High Availability and Disaster Recovery solutions like Always On Availability Groups and Failover Cluster
- Implemented Transactional Replication as a part of DR solution
- Extensive experience in implementing High availability and Disaster Recovery solutions like Replication (Snapshot and Transactional), Log shipping, Windows Failover, mirroring on physical and virtual machines
- Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server
- Extensive knowledge on Clustering(Active-Active/Active-Passive) and server consolidation
- Troubleshooting production issues and raising high availability
- Exposure on Storage Area Networks (SAN) and utilizing SanDisk space in a Windows Environment
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
- Extensively used the native tools like index tuning wizard or database tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
- Experience in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools
- Performance Tuning like identifying long running queries, Open Transactions, Blockings, Deadlocks, Trace Flags etc
- Auditing of database for users transactions, login and database action and removing orphan users
- Good at Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, re-org, table partitioning
- Good experience in implementing High Availability Solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
TECHNICAL SKILLS
Operating Systems: Windows NT/ 2003/2007/2008/2010 , Unix
Programming Languages: T-SQL, PL-SQL, HTML5, XML
Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Office, Access 97/2000/2003/2007/2010
ETL and REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)
Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, perfuming counters, SQL Server Management Utility, Query Analyzer
PROFESSIONAL EXPERIENCE
Confidential, Alpharetta, GA
SQL Server DBA
Responsibilities:
- Install, Manage and administer SQL server 2005/2008R2/2012/2014 servers.
- Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
- Deployment of databases, jobs, cubes from pre-production to production.
- Building SQL 2005/2008 cluster environments on VMware or Physical windows.
- Upgradation of SQL server versions and applying patches and hot fixes.
- Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
- Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
- Performed installations of SQL 2005/2008/2012 on clustered and standalone servers.
- Adding nodes to already existing clustered servers as a part of data load/High availability.
- Configured Transactional Replication and Log Shipping with SQL Server Management.
- Fix the Cluster and Replication issues on SQL 2005/2008/2012 servers with in very strong SLA’s
- Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
- Worked on weekly Issues reports which are generated as a part of infrastructure setup.
- Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.
- Install and upgrade packaged databases remotely by using red gate
- Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering.
- Performance tuning of databases by windows performance monitor and SQL Profiler.
- Used Index tuning wizard to redesign and created the indexes for better performance.
- Documenting the standard procedures on regular basis.
- Working on tickets/incidents within the SLA’s, as a part of operations support DBA.
- Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
- Resource planning for application migrations with project managers and web app teams.
- Involved in capacity planning, sizing and database growth projects.
- Worked in an environment with Change management process (Service-now tool) in place for all kind of production and non-production changes.
- 24/7 On Call production support.
Environment: MS SQL Server 2005/2008R2/2012, Windows 2003/2008/2012 , SSRS, SSIS, SSAS, PL/SQL, Microsoft Access.
Confidential, Peoria, IL
SQL Server DBA
Responsibilities:
- Installed and configured SQL Server 2005/2008 R2/2012 on Prod and Non-Prod environments
- Configured HADR techniques like replication (snapshot and transactional), Mirroring, log shipping and clustering on virtual and Physical environments
- Configured ALWAYS ON setup between different DATA Centers and on Multi Subnet Cluster
- Worked on side-by-side migrations of SQL server
- Applied service packs as a part of standardization project
- Implemented SQL server auditing to collect data for Quarterly audits
- Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler to find the resource bottlenecks
- Resolved locking and blocking issues
- Refresh non-prod environments with production data on regular basis
- Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
- Used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS
- Worked on Crystal Reports and Power Shell scripts
- Experience in writing DDL, DML statements, Indexes, Partitioning
- Provided RAID level suggestion for data files, log files and temp DB drives
- Used Index tuning wizard for optimal query performance
- Monitoring SQL Server LOGS, Application logs and analyzing the logs
- Reorganizing or Rebuilding Indexes based on the Index fragmentation
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Creating Backup strategies and scheduling them as a part of database maintenance plans.
- Provide 24*7 on support
Environment: SQL Server 2012/2008 R2/2005/2000, Windows 2003/ 2008 Server, Lite Speed, Microsoft SQL server Visual Studio 2005/2008 R2
Confidential, Miami, Florida
SQL Server DBA
Responsibilities:
- Installed and configured SQL Server 2005/2008 R2 on the server and client machines, provide connections and manage databases.
- Created and maintained various databases for Production, Development Servers using MS SQL Server 2005/2008.
- Planning the location of data, indexes, and Transaction log files on the disk.
- Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
- Resolved locking and blocking issues.
- Tuning the Production server to get the performance improvement.
- Running Index tuning wizard for optimal query performance.
- Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
- Experience working with IDERA for Performance Monitoring, Dead Lock, and Blocking.
- Monitoring SQL Server Logs, Application logs and analyzing the logs.
- Provided 24/7 support to SQL application developers in implementing them production server.
- Reorganizing or Rebuilding Indexes based on the Index fragmentation.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Creating Backup strategies and scheduling them as a part of database maintenance plans.
- Created the SSIS packages for executing the tasks, created the Jobs and scheduled for daily running.
- Involved in Change Data Capture process.
- To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
- Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, production support and Project review with client.
- To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
- To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
Environment: SSQL Server 2005/2008/2008 R2/2012 with clustering, Sybase, T-SQL, Lite Speed, Windows 2000.
Confidential
SQL Server DBA / Developer
Responsibilities:
- Installation and configuration of MS SQL Server 2008 R2/2005/2000
- Migrating data from SQL Server and 2008 R2
- Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning
- Involved in Optimization and normalization of database and tables
- Involved in conceptual and physical modeling of data using Erwin tool
- Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL)
- Part of team for analyzing and implementing the physical design for database
- Writing complex Stored Procedures to meet the business requirements
- Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives
- Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
- Designing and building data load procedures, using MS SQL Server
- Responsible for transferring of database and database objects from Development to Production Server using DTS
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures
- Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures
Environment: Windows 2003, SQL Server 2000/2005/2008 R2, SSIS.
Confidential
SQL Server Developer/DBA
Responsibilities:
- Installation, Configuration and Administration of SQL Server 2000/2005, with Multi-Instance Servers besides applied Security Patches.
- Performed security tasks such as creating users and user groups, and assigning appropriate permissions.
- Created Maintenance Plans for backups, rebuilding of indexes, database integrity checks and update statistics.
- Used Profiler to analyze long running queries and tune them to optimize.
- Performed daily tasks such as backup and restore by using SSMS and third party tools besides working on Disaster recovery and business continuity plans.
- Implemented log shipping and database mirroring as part of disaster recovery plan.
- Created automatic alert reporting systems using database mail configuration manager.
- Used DDL and DML for writing complex T-SQL code, Triggers, Stored Procedures and views.
- Used the SSIS Import/Export, migrated to other databases such as Oracle and DB2.
- Deployed periodic reports based on the statistical analysis of the data using SSRS.
- Involved in 24x7 on call support on rotation basis.
Environment: Windows 2003, SQL Server 2000/2005, SSIS, SSRS, Performance Monitor.
