Sql Server Dba Resume
KY
SUMMARY
- Over 7+ years of IT experience on Database Administration and Deployment with MS SQL Server technology and managing VLDB (very large database).
- Experience in Software Development Life Cycle (SDLC) and project methodologies.
- Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2000/2005/2008/2008 R 2/2012/2014.
- Experience in tuning SQL queries and improving the performance of the database
- Experience in implementing and maintaining High Availability solutions like Clustering, Database Mirroring, Replication, Log shipping and AlwaysOn.
- Proficient in Database migration to new versions and editions of SQL Server as part of datacenter or server consolidation or upgrade projects.
- Experience in SQL ServerPerformance Tuning using tools like System Monitor, SQL Server Profiler, DMVs, Optimized expensive running Queries using Database Engine Tuning Advisor, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
- Created custom - tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task.
- Proficient with Disaster Recovery Solutions.
- Experience in implementingSQL Server Security and Database Permissions.
- Experience in IIS Application Server and setting up App pools.
- Experience in PowerShell scripts and creating custom dba reports in SSRS
- Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
- Well experienced in performing root cause analysis and using SQL Profiler for troubleshooting.
- Experience in working RAID and SAN environment and have good understanding in capacity planning.
- Transformed data between servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Audited database user’s audits using SQL profiler and costumed stored procedures\packages.
- Experience in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
- Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems
- Knowledge in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
- Experience working with developers on large scale projects and solutions.
- Exposure to various tools and technologies like redgate, spotlight and litespeed for database administration, monitoring and maintenance.
TECHNICAL SKILLS
Operating Systems: Windows 9x/NT/2000/XP, Windows server 2000/20
Databases: MS SQL Server 2000/2005/2008 R2/2012/2014
Database Tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, SQL Client Configuration utility, Backup and Restore, Replication, Log Shipping, Redgate, Idera
ETL Tools: DTS (Data transformation services), SSIS (SQL Server Integration Services)
Modeling Tools: Erwin, MS Visio
Languages: SQL, Transact SQL (T-SQL)
Reporting Tools: SSRS (SQL Server Reporting Services)
PROFESSIONAL EXPERIENCE
Confidential, KY
SQL Server DBA
Responsibilities:
- Installation, Configuration and Administering of SQL Server 2012/ 2008/2005/2000 on Dev, QA & Production environments and applied Service packs.
- Worked with SAN, Network team, troubleshoot system and sql server performance issues, proactively identify disk/Io bottlenecks issues, setup Monitoring and Alerting for the migrated systems.
- Used upgrade advisor for compatibility check for databases before updates.
- Performed in-place and side by side migration of existing SQL server 2005 user’s client critical databases.
- Created and Maintained the Alwayson Availability groups.
- Installed and Configured IIS application server.
- Identified long running queries and tune them. Resolved blocked and locked objects issues.
- Created new Clustered, Non-Clustered Indexes andconstraintson frequently used tables in application.
- Designed Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures.
- Implementation of Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Used DBCC commands, System monitor, Dynamic views, Execution plans as part of trouble shooting and performance tuning.
- Developed automated scripts, standards and guidelines to maintain develop and administer the SQL Server database.
- Implemented Replication (Snapshot and Transactional) between primary production server and reporting server.
- Generated periodic reports based on the statistical analysis of the data using SQL ServerReporting Services (SSRS).
- Installed & Administered two node cluster Active/Active on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
Environment: Windows 2003/2008, SQL Server 2012/ 2008/2005/2000 , SSIS, SSRS, IISSpotlight and Redgate tools.
Confidential, KY
SQL Server DBA
Responsibilities:
- Installed SQL server and its component on Windows 2003/2008 cluster servers
- Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task.
- Upgraded/migrated databases from lower version of database to higher version
- Excellent in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
- Well versed in various high availability solutions like clustering, mirroring, log shipping.
- Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems
- Created, altered, maintained system roles and permissions to users on various database objects.
- Loaded flat files into stage tables by using Bulk Copy ProgramBCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
- Planned and co-coordinated database security measures
- Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
- Tested and Implemented Log shipping technique for disasters recovery.
- Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
Environment: Windows 2003/2008 Enterprise, SQL Server Management Studio, MS-SQL Server 2005/2008 R2, T- SQL, SSIS, SSRS, SSMS, DTS, SQL Sentry & SQL LiteSpeed.
Confidential, NJ
SQL Server DBA
Responsibilities:
- Install clustered and stand-alone SQL server 2005 and 2008 and patched them periodically.
- Implemented Database Mirroring and Transactional Replication as a part of DR plan;
- Exposed to Performance Monitor, Database Tuning Wizard, Performance monitoring tools, Network Load balancing, Performance counters, analyzing profiler outputs, Mirroring, IIS (Internet Information Services) Microsoft Failover clustering.
- Administered and managed SSIS packages and SSRS reports.
- Implemented the new features like Data partitioning, Snapshot isolation, database mirroring, database snapshot, ETL (Extract Transform Load), DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection
- Worked in Active passive cluster environment
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
- Perform database backups by using litespeedbackup tool.
- Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
- Created Linked Server between SQL Servers. Worked with SQL Profiler/SQL Trace to Generate Traces.
- Maintaining the database consistency with DBCC at regular intervals nitor SQL Server log files.
Environment: Windows Server 2003/2008, MS SQL Server 2008/2005/2000 , SQL Server Reporting services, SQL, T-SQL, SQL Query Analyzer, Profiler, Erwin, VSS.
Confidential
SQL Server DBA
Responsibilities:
- Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
- Evaluated data storage considerations to store databases and transaction logs.
- Implemented Database Mirroring and Transactional Replication as a part of DR plan.
- Handled Active/Active Clustering between two Production Servers and performed daily backups and developed recovery procedures.
- Created, built and deployed successfully SSIS packages by using BIDS. Migrated DTS packages to SSIS 2005 packages.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Responsible for monitoring and making recommendations for performance improvement in databases.
- This involved index creation, index removal, index modification, file groupmodifications, and adding scheduled jobs to re-index and update statistics in databases.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Maintaining the database consistency with DBCC utility at regular intervals.
- Using Log shipping for synchronization of database.
Environment: SQL Server 2008/2005/2000 , Windows 2003, Microsoft Windows 2008 Server
Confidential
SQL Server Developer
Responsibilities:
- Performance tuning of SQL servers and application issues related to migrations.
- Testing of applications for performance, data integrity and validation issues.
- Data Transfers between various servers using BCP.
- Worked on High Availability, Log shipping, Mirroring, Disaster Recovery and Replication
- Analyzed long running, slow queries and tuned the same to optimize application and system performance
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services
- Setup Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.
Environment: SQL Server 2005/2000, Windows 2003/ 2008 Server