We provide IT Staff Augmentation Services!

Sql Server Dba Resume

5.00 Rating

High Point, NC

SUMMARY:

  • 8+ years of experience as an SQL DBA in Production/UAT/QA/Development & strong programming skills.
  • Strong experience in SQL Server Database Administration.
  • Strong Experience in upgrading SQL server 2005/2008R2/2012 to SQL server 2014.
  • Experience in updating security patches and service packs in database systems.
  • Excellent Knowledge in RDBMS concepts and constructs.
  • Great experience in implementation of Always on High Availability Groups in SQL Server 2012 and SQLServer 2014.
  • Experience in Windows 2008R2 and Windows 2012.
  • Extensive knowledge in SQL Server performance Analysis, implementation of Resource Governor, Extended Events and troubleshooting live production issues.
  • Excellent knowledge of Windows Active Directory Domain Services.
  • Expert in installing SQL Server 2008R2, 2012 and SQL Server 2014 in clustering mode to provide High Availability/Disaster Recovery.
  • Experience in Extracting, Transforming, and Loading (ETL) data using SSIS.
  • Experience in Performance Tuning, Query Optimization, Client/Server connectivity, DatabaseConsistency Checks using DBCC Utilities, running Ad - hoc queries.
  • Highly skilled in implementing different types of Replication Models like Snapshot, Merge Transactional andPeer to Peer.
  • Expert in managing Cluster Servers and handling Replication in SQL Server 2005/2008/2012 and 2014.
  • Experience in writing Distributed Queries between SQL Servers.
  • Excellent skills in database backup, replication, recovery, restoration, shrinking of database andDatabase files, SSIS and Linked servers.
  • Great knowledge of Data Dictionary and Data Warehousing.
  • Experience in creating SSIS packages to import and export data.
  • Good SQL Server administration skills including user authorizations, Database design/creation, Tables, Views,Indexes, Server level Triggers and Database level Triggers.
  • Strong knowledge on SQL Server agent scheduling.
  • Great Experience in design of physical data storage.
  • Experience in data extraction from various sources such as MS Access and MySQL, MS Excel.
  • Experience in creating Server Audit Specifications, Server level Audit, Policies, Policy conditions andFacets.
  • Expert in defining data source and building data source views.
  • Highly proficient in working with users to gather requirements, analyze them, and subsequently use designTools to model the requirements.
  • Experience in administrating the created reports and assigning permission to the valid users forExecuting the reports.
  • Expert in Database Design and data interaction process between Web server and Database server.
  • Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing,Implementation, deployment & maintenance of Projects.
  • Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emergingTechnologies and adapt quickly.
  • Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.
  • Excellent Communication and inter personal Skills when working with developers, project managers and

TECHNICAL SKILLS:

Operating System: Windows 7/XP, Windows Server 2000/2008/2008R2/2012/Linux

RDBMSMS: SQL SERVER 2000/2005/2008/2008R2/2012/2014

Tools: SQL Query Analyzer, SQL Profiler, DTS/SSIS, SSRS, SSAS

Third Party: BackupTSM, TDPSQL, VERITAS Net Backup, VERITAS Backup Exec

Monitoring Tools: Microsoft Operations Management (MOM), NetIQ, Scomm, Spotlight

Third Party Tools: Red Gate, HP Service Manager, Service Now, DBArtisian

Application Servers: IIS 6.x/7.X

PROJECT EXPERIENCE:

Confidentia, High Point, NC

SQL Server DBA

Responsibilities:

  • Backup all users as well as System databases from source and restored user databases on destination server.
  • Scripted out Source Logins, DBMail, credentials, Audit, Server Audit specifications, Linked Servers, existing Replication, Alerts, Operators and proxies, SQL Server Agent Jobs and Triggers.
  • Ran the scripts such as Logins, Linked Server, DBMail etc. on the target SQL Server 2014 and restored System database msdb to migrate all the application related SQL Server agent Jobs.
  • Changed Compatibility of all SQL Server 2012 SP2 databases to SQL Server 2014.
  • Setup SQL Server 2012 Cluster environment to support Sales related databases
  • Setup Hyper-V Windows 2012 environment.
  • Setup Shared disks using ISCSI initiator and Installed Windows Clustering features on all cluster nodes
  • Joined all the nodes to Domain and Installed SQL Server 2012 in Cluster mode.
  • Documented all the procedure for future references and provided technical support for any issues.
  • Extensively involved in Both Server Level and Database Level security of SQL Server 2008R2/2012/2014 such
  • As creating logins, different database/Application roles, Assigning Role according to the requirements.
  • Wrote handy scripts to transfer logins from SQL Server 2008R2 to 2012.
  • Involved in backup strategies, Disaster Recovery modeling in production servers.
  • Responsible for creating and scheduling jobs such as backup, tuning the databases, daily reports notifications
  • Monitoring Customized jobs to keep track of job failure in database server.
  • Responsible for server level as well database level performance monitoring using various tools such as system monitor, SQL profiler, activity monitor and TSQL.
  • Responsible for troubleshooting and problem resolution of production, test and development environment.
  • Installed and Configured SSIS 2014.
  • Installed and Configured SSRS 2014.
  • Strongly involved in building database Objects.
  • Responsible for installing SQL Server, Services packs and hot fixes.
  • Responsible for loading data using openrowset, bulk insert from different sources into SQL server and vice versa.
  • Involved in creating and administrating clustered Environment, Virtual (VM), and HyperV Environments.
  • Responsible for data transfer using SSIS packages in SQL server 2012 and 2014
  • Involved in Capacity planning.
  • On call support 24/7.
  • Responsible for high availability of the system, Log Shipping, Clustering, database mirroring in SQL Server 2012 and 2014.
  • Responsible for configuring/troubleshooting the replication.
  • Interacting with application development team to keep system as well as teams on the same page.
  • Documenting of all process flows for the team to assist any new addition to the DBA team.

Environment: MS SQL Server 2008R2/2012 and 2014, MS SQL Server Reporting service 2012/2014,SSIS 2012/2014, Windows 2008/2008R2 and 2012, Availability Group 2012 and 2014, Windows 2008R2 and 2012 Clustering, DBArtisian, NETIQ V7/8.

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

  • Setup Disaster Recovery by setting up clusters between SQL Server Instances on Primary - Primary and Secondary - Secondary Sites and create High Availability between Primary and Secondary sites by creating AlwaysOn Groups.
  • Implemented SQL server encryption security (i.e. Certificate) to make databases more secure.
  • Used cryptography techniques on encrypted filed to run faster query.
  • Upgraded SQL Server 2008R2 to SQL Server 2012 SP2 (Parallel Migration)
  • Upgraded SQL Server 2005 to SQL Server 2008R2 (Inplace Migration)
  • Used profiler and performance tuning to get better performance.
  • Created stored procedures for the business logic using T-SQL.
  • Created job schedules to automate the routine tasks.
  • Performed Database Normalization.
  • Made database back up (Full, Differential, Log and Tail Log) and restored it.
  • Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
  • Imported and Exported data from different sources other than SQL server (such as Oracle, DB2, Access, Flat files) using Import/Export wizard.
  • Set up Mirroring and Log Shipping in SQL Server for DR purposes.
  • Involved in the complete data warehouse development life cycle.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Created Linked Server to link a remote SQL Server.
  • Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
  • Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
  • Participated in design of LOGICAL and PHYSICAL databases and applied knowledge of database design standards.
  • Monitored index fragmentation and performed index rebuild at regular intervals.
  • Created Policies, Policy Conditions, Facets and Extended Events.
  • Created Resource Pools and Workload Groups in Resource Governor.

Environment: MS SQL Server 2008R2/2012, MS SQL Server Reporting service 2008R2/2012,SSIS 2008R2/2012, Windows 2008/2008R2, Availability Group 2012, Windows 2008R2 and 2012 Clustering

Continental, Auburn Hills, MI

SQL Server DBA

Responsibilities:

  • Installation, configuration and maintenance of MS SQL Server 2005.
  • Set up Windows 2003 Failover Clustering.
  • Configured Failover Clustering Using MSCS (Microsoft Clustering Services).
  • Installation of SQL Server 2008 R2 in cluster mode.
  • Created & managed the database users’, login IDs and security.
  • Created database objects such as tables, views, stored procedures, indexes etc.
  • Maintained security policies, Managed Logins and Users: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
  • Created and modified stored-procedures, triggers, views.
  • Wrote T-SQL for the retrieval of the data.
  • Extracted Data from MS ACCESS And MySQL.
  • Created SSIS package to export and import data from SQL Server to Access, text and EXCEL files.
  • Checked performance and tuning, Full Text indexing, query optimization and query execution plans.
  • Used database consistency checks using DBCC utilities.
  • 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.
  • Wrote distributed queries for Linked Servers.
  • Exposure to running jobs in Enterprise Manager using job-scheduling tool.
  • Setting up Replication using MS SQL Server 2005 using SQL Server Replication.
  • Created ad-hoc reports using MS reporting services.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
  • Involved in resolving locking and blocking issues.
  • Designed the Dimensional modeling of the Data warehouse using ERwin 4.0.
  • Data Warehousing using SSIS Package.
  • Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.

Environment: SQL Server 2000 Enterprise Edition, SQL 2005, SQL Server 2008 R2, MS SQL Server Analysis service 2005/2008R2. SSIS,BO XI, Enterprise Manager, ERWIN, UML, MS Project, MS Access 2000 & Windows 2K platform, IIS and XML

Confidential

SQL Server DBA

Responsibilities:

  • Extensively involved increating database objects such as tables, views, stored procedures, indexes etc.
  • Involved in Capacity planning.
  • Installation, configuration and maintenance of MS SQL Server 2005.
  • Monitoring disk space utilization, CPU performance, I/O activities and automation of maintenance jobs using SQL Mail notification solutions.
  • Setting up processes for regular backups and restore methods.
  • High emphasis on database security, permissions, user management.
  • Used database consistency checks using DBCC utilities.
  • Installing, upgrading and applying the latest service packs/hot fixes.
  • On call support 24/7.
  • Created and modified stored-procedures, triggers, views.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Monitored index fragmentation and performed index rebuild at regular intervals.
  • Refreshing the SQL Databases and Performance Tuning.
  • Created and Maintained SQL Server 2005 SSIS Packages.
  • Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
  • Involved in resolving locking and blocking issues.
  • Extensively involved Extracting Data from MS ACCESS And MySQL.

Environment: SQL Server 2000 Enterprise Edition, SQL 2005, MS SQL Server Analysis service 2005, SSIS, Enterprise Manager, ERWIN, MS Project, XML, MS Access 2000 & Windows 2K platform

We'd love your feedback!