We provide IT Staff Augmentation Services!

Sql Server Dba Resume

5.00/5 (Submit Your Rating)

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.

We'd love your feedback!