We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

3.00 Rating

Minneapolis, MN

SUMMARY

  • 7+ years of IT experience as SQL Server Database administrator, especially in tuning and optimization of database, providing 24/7 support of both development and production databases.
  • Expertise in Performance Tuning, DTA and Query Optimization
  • Good experience in Debugging Stored Procedures, triggers and troubleshooting database issues.
  • Experience using database tuning adviser to get index recommendation for complex database queries.
  • Hands - on working experience in Installing, configuring, upgrading and managing SQL Server 2008-R2/2012/ 2014 and required Service Packs. Proficient in creating maintenance plan to automate backup jobs, check database integrity, reorganize and rebuild indexes.
  • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO). Experienced in implementing efficient Disaster prevention and Recovery Strategies by creating backup and restore plans according to business RTO and RPO.
  • Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, granting database and application roles to users and groups.
  • Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
  • Involved in Data Center Migration and Consolidation Project.
  • Implemented Database Mirroring with high-performance and high-safety mode.
  • Configured and maintain Log shipping, Clustering (Active/Passive), Always-on.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
  • Experience handing Batch processes using BCP, SSIS packages, Import & Export wizard.
  • Configured and deployed SSIS and SSRS packages from development to the production environment.
  • Have exposure to Light Speed and Spotlight as a third-party backup and monitoring tool. Experience using spotlight to troubleshoot database performance issues like blocking, deadlocks and long running queries.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008-R2/2012

Database Tools: Management Studio, SQL Server Data Toots, Business Intelligence Development Studio, SQL Profiler, Database Tuning Wizard

Programming Languages: T-SQL

ETL Tools: SSIS

Backup and Monitoring Tools: Spotlight, LightSpeed, Redgate

Operating Systems: Windows 2003 / Windows 2008

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. SQL Server DBA

Responsibilities:

  • Administers all SQL server database, reporting services and SSIS packages.
  • Creates complex queries, stored procedures and functions.
  • Models and Manages Database for various applications.
  • Creates and maintains advanced ETL (Extract, Transform, and Load) systems to feed other external and internal systems, using Integration Services to extract data from a variety of sources.
  • Synchronizes data among multiple systems.
  • Performs data analysis for various source systems.
  • Manages the flow of data between application systems; creates reports of varying complexity for end users; creates advanced SQL query to import and export data.
  • Creates and maintains advanced reports; gathers technical requirements from end users, develops procedures in SQL server to extract the data, develops the report using Reporting Services, and deploys the report to the appropriate application.
  • Troubleshoots application and data issues across a variety of applications, and provides solutions and recommendations as applicable.
  • Provides technical analysis to determine appropriate solutions to meet business requirements.
  • Maintains and enforces all aspects of system security and confidentiality of records and information; monitors operations and identifies security issues and violations of MPS policies and guidelines.
  • Documents work completed; maintains work log of service requests, equipment malfunctions, software errors and failures, equipment locations and technical configurations; identifies and reports trends and technical problems which need to be addressed by improved procedures and policies.
  • Demonstrates courteous and cooperative behavior when interacting with students, clients, visitors, and MPS staff; acts in a manner that promotes a harmonious and effective workplace environment
  • Enthusiastically promotes the Superintendent’s goals and priorities in compliance with all policies and procedures.
  • Maintains absolute confidentiality of work-related issues, records and MPS information.
  • Has access to any and all documents contained on District servers and individual office personal computers. This includes highly confidential documents relating to individual employee private information, confidential departmental documents, including collective bargaining negotiations. Maintains strict confidentiality of all document contents on any District server or personal computer.
  • Other duties or tasks may be assigned on an as-needed basis
  • At times may be required to work outside normal business hours and work extended hours to accomplish requirements of the position.

Environment: T-SQL, SQL Server 2000/2005/2008 R2/2012/2014 SSRS, TCP/IP, SSIS, ETL, Windows 2005, 2008, Red gate, Spotlight.

Confidential, NYC, NY

Sr. SQL Server DBA

Responsibilities:

  • Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Good experience in analyzing the execution plan and index management for better Query Optimization.
  • Good experience in identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
  • Proactively identify missing indexes and create them as necessary after testing to improve query performance.
  • Work with developers to implement best practices while programming database objects. Worked with them to optimize database before releasing it to into production.
  • Involved in General Database Administration, Query Performance tuning.
  • Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.
  • Created databases, logins, roles and granted appropriate permissions.
  • Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
  • 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 Log Shipping and Mirroring for day one critical database as a High Availability Solution.
  • Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.
  • Setup, implement, and maintain industry standards in database management.
  • Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Imported and Exported data (Migrated) from different sources other than SQL server (such as Access, Flat files) using Import/Export wizard.
  • Worked well with team members to bring the databases up to the business requirement.

Environment: T-SQL, SQL Server 2000/2005/2008 R2/2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate, Spotlight.

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

  • Installed SQL Server using standard checklist.
  • Query Optimization for fast and prompt data processing.
  • Strong Knowledge of Query performance tuning.
  • Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
  • Created and managed clustering environment such as active/passive clustering.
  • Configured and managed log shipping and database mirroring.
  • Monitoring the servers using Spotlight third party Quest software to detect CPU usages, performance issues, and disk performance.
  • Using indexes, fine-tuned databases to perform query faster.
  • Worked with DTA to improve performance of queries by implementing indexes to the missing tables.
  • Created Triggers to enforce data and referential integrity.
  • Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.
  • Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
  • Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2000/2005/2008 R2, Log Shipping, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, Spotlight.

Confidential, New York City, NY

SQL Server DBA

Responsibilities:

  • Performed side-by-side migration and following both pre and post checklist for database migration.
  • Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2 and installed patches and service packs on the SQL Server 2008 R2.
  • Troubleshoot all migration issues on the destination servers and created all maintenance plans, jobs, logins while performing database integrity checks.
  • Used various methods to tune queries such as DBCC commands, DTAs and implementing indexes.
  • Provided excellent 24X7 Production support with on call pager support.
  • Automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Creation and maintenance of Databases, creating Roles and managing user permissions, resolving blocks and deadlocks.
  • Configured Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
  • Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery
  • Worked with LightSpeed as a Backup solution for large database backups.
  • Configured and deployed SSIS and SSRS packages from development to production servers.
  • Implement best practices for Database Monitoring, Backups and Restores.

Environment: SQL Server 2000/2005/2008 , Snapshot replication, Transactional replication, Merge replication, SSIS, SSRS Query Analyzer, Performance Tuning.

Confidential

SQL Server DBA

Responsibilities:

  • Installed, configured SQL Server 2005 R2 for both development and production environment and applied necessary hot fixes.
  • Setting up database Backup and Recovery procedures for development and production servers.
  • Configured Database mail Agent for sending Automatic emails on Errors to designated individual.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
  • Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Worked closely with developers to recommend indexes to improve query optimization and performance.
  • Configured linked servers to enable the SQL server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.
  • Setup, configure and administer Snapshot and Transactional Replication on MS SQL Servers.
  • Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.
  • Worked with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.
  • Participated and worked with Data Center teams on the infrastructure, network and storage issues while defining database maintenance windows.
  • Provide off hour support during peak business activity period and during application deployments.

Environment: SQL Server 2000/2005 with clustering, Replication, mirroring, T-SQL, Windows 2000/2003, SSIS, Query Analyzer, SQL Profiler, Database tuning Advisor.

We'd love your feedback!