We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)

Newark, NJ


  • Over 7 years of IT experience in MS SQL SERVER 2005/2008R2/2012 Administration (DBA) in windows environment.
  • Excellent knowledge in Relational Data Base Management System.
  • Well experienced in Installing, Configuring, and upgrading SQL Server.
  • Experience in Migrating from SQL server 2008R2 to 2012by using side - by-side upgrade process, and documented the Upgrade Process.
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot, Transactional, and Merge), Log shipping, Clustering (Active/Active and Active/Passive), AlwaysOn and Database Mirroring.
  • Experience in implementing and managing transactional, merge, and snapshot Replication models.
  • Experience in establishing routines to ensure that indexes are defragmented regularly and statistics are up-to-date.
  • Best practice implementation including maintenance plans, Jobs scheduling and notification, proactive monitoring and alerting.
  • Expertise in using DBCC trace flags, handling blocking and deadlock situations.
  • Experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, DMF’s, Index Tuning Wizard and Windows Performance Monitor.
  • Experience in resolving issues and identify root cause and proactively improve the reliability of the data
  • Expertise in creating and managing databases and users. Evaluating user permissions and granting access to authorized users using least privileges policy.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Excellent skills in database backup, recovery, and Log Shipping.
  • Experience with Integration Service (SSIS), Analysis Service (SSAS), and Reporting Services (SSRS) installing, configuring, deploying, migrating, scheduling jobs, importing and exporting.
  • Experience with third Party tools like Redgate and Spotlight.
  • Very good communication, conceptual, analytical, writing and documentation skills


Databases: MS SQL Server 2005, 2008R2, 2012

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Upgrade Wizard and Database Tuning Wizard.

Programming: T-SQL, C


Backup and Monitoring: Spotlight, Redgate, Fog Light

Operating systems: Windows 2003 and 2008 servers


Confidential, Newark, NJ

SQL Server DBA


  • Installed and Configured SQL Server 2012 Servers in Production Environments and migrated SQL Server databases from SQL Server 2008 to SQL Server 2012.
  • Performed side by side upgrade wherever it was needed and documented the process.
  • Setup ALWAYSON for critical database as a High Availability Solution.
  • Created various availability groups depending up on the requirements of the particular databases
  • Created and managed clustering environment such as active/passive clustering.
  • Built and maintained SQL Server failover clustering and single cluster node solutions for specified applications.
  • Created databases, logins, roles and granted appropriate permissions.
  • Created jobs, alerts, activity logs, error logs to capture any possible errors.
  • Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Supported 24*7 production support and solved all kinds of critical problems.
  • Participated in SDLC methodologies such as planning, analysis, design and implementation.
  • Setup, implement, and maintain industry standards in database management.
  • Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Worked well with team members to bring the databases up to the business requirement.

Environment: T-SQL, SQL Server 2012, OLTP, ALWAYSON, SSIS, Replication, Windows 2008, Redgate and Spotlight.

Confidential, San Jose, California

SQL Server DBA


  • Identify long running queries using profiler and tune them using various techniques to improve performance.
  • Identify top 10 slow running stored procedures and tune them.
  • Identify long running jobs and improve their performance. One of the jobs that I tuned to less than 15 minutes was running for 22 hours.
  • Identify heap tables across all databases and implemented clustered indexes with or without primary key.
  • Using indexes, fine tuned databases to perform query faster.
  • Worked with developers to tune their stored procedures in the development stage before released to production.
  • Worked with DTA to improve performance of queries by implementing indexes to the missing tables.
  • Monitoring SQL server performance using profiler to find performance issues and deadlocks.
  • Monitoring the servers using Spotlight third party Quest software.
  • Created Triggers to enforce data and referential integrity.
  • Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
  • Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.
  • Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2008 R2, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, Spotlight.

Confidential, Palo Alto, CA

SQL Server DBA


  • Migrated SQL Server databases from SQL Server 2000/2005 to SQL Server 2008 R2 and installed patches and service packs for the SQL Server 2008 R2.
  • Migrated DTS packages from SQL Server 2005 to SQL Server 2008 R2 as SSIS packages.
  • Configured MS SQL Server 2008 R2 built-in log shipping from primary server to standby server
  • Configured database mirroring as a high availability solution with the primary, mirrored and witness servers.
  • Configured database mirroring in high safety and high performance modes depending on the requirement.
  • Creation and maintenance of Databases, creating Roles and managing user permissions, resolving blocks and deadlocks.
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • SQL Development- experience in creating database architecture with associated schema as part of a software design process.
  • Work with IT and business teams to determine and define database maintenance windows.
  • Implement best practices for Database Monitoring, Backups and Restores.
  • Work with Data Center teams on the infrastructure, network and storage issues.
  • Provide off hour support during peak business activity period and during application deployments.
  • Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery

Environment: SQL Server 2008, database mirroring, log shipping, SSRS, Query Analyzer, and Performance Tuning.

Confidential, Morristown, NJ

SQL Server DBA


  • Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.
  • Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
  • Configured Merge replication for the particular applications.
  • Set up jobs and Database maintenance plans for backups, index rebuilding and statistics update.
  • Performed backups and restores on servers as needed or for a company process.
  • Installed and maintained SSRS on our Enterprise SQL server 2005 environment.
  • Prepared new documentation and maintained updates on existing documentation.
  • Transformed packages from one server to the other in SQL 2000/2005 using SSIS.
  • Used performance Monitor, Profiler, Activity Monitor to troubleshoot Dead Locks Long running queries.
  • Provided 24 x7 supports for production and monitored issues proactively before client complaints.
  • Optimization of T-SQL procedures using SQL Server tools.

Environment: SQL Server 2005, transactional replication, merge replication, SSRS, SSIS, Query Analyzer, and Performance Tuning.


Jr.SQL Server DBA


  • Created User defined roles on SQL Server 2005 to meet certain security concerns.
  • Created User access, SQL Logins, Roles and Schemas for different database objects
  • Created Jobs and scheduled them for database backup and to run scripts.
  • Configured, deployed and monitored SSIS Packages.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Configured and maintained Microsoft SQL Server 2005 fail over clustered environment.
  • Followed the checklist to install sql server 2005 and managed it.
  • Implemented and monitored Replication to make data available at different locations.
  • Acknowledged SQL Server Alerts in the environment and resolving.
  • Monitoring and resolving the alerts from SQL Server boxes in Production Environments.
  • Problem analysis/making proposals for alternative solutions.
  • Performed SQL Server tuning to improve performance.
  • Coordinated with different teams during production releases
  • Recommended next generation database enhancement
  • Provided 24 x7 supports for production and monitored issues proactively before client complaints.

Environment: SQL Server 2005, T-SQL, SQL Server Integration Services, SQL Server Reporting Services.

We'd love your feedback!