We provide IT Staff Augmentation Services!

Production Sql Dba Resume

0/5 (Submit Your Rating)

Baltimore, MD

OBJECTIVE

  • Challenging opportunity as Database Administrator with extensive Production DBA Support in which I can contribute to the growth of the company while further developing my technical and management skills.

SUMMARY

  • A Microsoft Certified (MCDBA, MCSE) Senior SQL DBA with a Master’s Degree and 15+ years of Total IT Experience, With 11 + years of Database Administration with Windows Environments and Application maintenance experience.
  • Installation and Configuration Production Servers of SQL Server 2008R2/SQL Server 2012 on Windows 2008 R2 (2 node clusters)
  • Installation and Implementation SQL Server 2012 Always - On High Availability and Disaster Recovery setup
  • Upgrading SQL Server 2008R2 to SQL Server 2012 R2 using side-by-side methods
  • Tuning the performance of the databases applying MS recommendations, using perfmon and SQL Profiler
  • Planning and Creating Databases as per Microsoft Recommendations
  • Creating and Maintaining SSIS SQL Server2008R2 and 2012
  • Installing Reporting Services and creating test reports to make sure all working as per expectations
  • Supporting 24*7 SQL Server Production Support
  • Participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates
  • Setting up processes for regular backups and restore methods, and ensuring the processes are followed
  • Disaster Recovery Planning & Implementations Server Cluster
  • Upgrade experience from SQL Server 2005 to SQL Server 2008, SQL Server 2012 and SQL Server 2008 to SQL Server 2012
  • SQL Legacy SQL Servers Decommissioning activity
  • Setting up of Replication (Transactional)
  • Setting up of Database Mirroring
  • Database Migration
  • Regular Database Administration Active Extensive SQL experience in handling the entire spectrum of all tasks including installation, version control, patching, upgrade, migration, configuration, performance monitoring, tuning, security, backup & recovery
  • Performed SQL user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security
  • Expert in SQL Server backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning
  • Experience in Disaster Recovery, Database Migrations
  • Experience in managing the large multi instances
  • Expertise in SQL Server performance tuning Very Large Databases, Capacity planning
  • Expertise in in managing more Databases in SQL up to the size of 5 TB

TECHNICAL SKILLS

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

RDBMS: MS SQL SERVER 7.0/2000/ 2005/2008/2008 R2/2012ToolsSQL Query Analyzer, SQL Profiler, DTS/SSIS, OSQL.

Third Party Backup: TSM, TDPSQL, VERITAS Net Backup, VERITAS Backup Exec, LiteSpeed

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

Third Party Tools: BMC Remedy, HP Service Manager, Service Now, Team Track, JIRA,Nagios.

Application Servers: IIS 6.x/7.X

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Database Administrator

Responsibilities:

  • Resolving Performance issues and if needed SQL Deployment Role backs
  • High emphasis on database security, permissions, user management and following best industry practices
  • Setting up monitoring through batch scripts
  • Handling Daily, weekly and monthly Data feed job failed issues and resolving
  • Creating and verifying the databases and making sure it meets Microsoft Recommendations
  • Tuning the performance of the databases applying MS recommendations, using perfmon and SQL Profiler
  • Production database administration of highly critical databases
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments
  • Installed, configured and managed the SQL Server Cluster instances
  • Scheduling the database monitoring scripts and backup status
  • Refreshing the test databases and schemas using Import/Exports
  • Resolved the database performance related issues
  • Supporting application end user issues and providing solutions

Environment: Windows 2003/2008R2/ Servers, SQL server 2008/SQL Server

Confidential, Baltimore, MD

Production SQL DBA

Responsibilities:

  • Deployments, releases and Production support
  • Resolving Performance issues and if needed SQL Deployment Role backs
  • High emphasis on database security, permissions, user management and following best industry practices
  • Setting up monitoring through batch scripts
  • Handling Daily, weekly and monthly Data feed job failed issues and resolving
  • Installing MSSQL Server 2008, 2008, 2008 R2, SQL server 2012/SQL on Windows 2008 R2/2012 as per Microsoft Recommended configurations
  • Creating and verifying the databases and making sure it meets Microsoft Recommendations
  • Tuning the performance of the databases applying MS recommendations, using perfmon and SQL Profiler
  • Upgrading and applying the latest service packs/hot fixes for SQL 2005 and SQL 2008 Instances
  • High availability through Clustering, Mirroring, replication
  • Production database administration of highly critical databases
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments
  • SQL Server databases upgraded from SQL Server R2version
  • Installed, configured and managed the SQL Server Cluster instances
  • Configured SQL Server2008R2 Replication and Log-shipping
  • Scheduling the database monitoring scripts and backup status
  • Refreshing the test databases and schemas using Import/Exports
  • Migration from SQL Server 2005 to SQL Server 2008 R2
  • Resolved the database performance related issues

Environment: Windows 2003/2008R2/ Servers, SQL server 2008/SQL Server

Confidential, MD

Production DBA

Responsibilities:

  • Active participation with customers in understanding their business process and suggesting optimal database structure, practices and tools on specific projects, ensuring high customer satisfaction rates
  • Setting up processes for regular backups and restore methods, and ensuring the processes are followed
  • Fully understand the SLA commitment and meet the standards
  • High emphasis on database security, permissions, user management and following best industry practices
  • Setting up monitoring through batch scripts
  • Deploying ETL packages and resolving failed jobs
  • Installing MSSQL Server 2008, 2008, 2008 R2, SQL server 2012/SQL on Windows 2008 R2/2012and as per t Recommended configurations
  • Creating and verifying the databases and making sure it meets Microsoft Recommendations
  • Tuning the performance of the databases applying MS recommendations, using perfmon and SQL Profiler
  • Upgrading and applying the latest service packs/hot fixes for SQL 2005/2008
  • High availability through Clustering, Mirroring, replication
  • Production database administration of highly critical databases
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments
  • Installation of SQL Server 2008 R2/2012. Upgrading SQL Server 2008R2 to SQL Server 2012 using side-by-side methods
  • Writing RCA’s for recurring issues
  • SQL Server databases upgraded from SQL Server R2version
  • Installed, configured and managed the SQL Server and Cluster instances
  • Configured SQL Server2008R2 Replication and Log-shipping
  • Database designing and capacity management for application new tables and changes
  • Scheduling the database monitoring scripts and backup status
  • SQL Server database backups using NetApp Snapshot tool
  • Refreshing the test databases and schemas using Import/Exports
  • Resolved the database performance related issues

Environment: Windows 2003/2008R2/ Servers, SQL server 2008/SQL Server

Confidential, NYC, NY

SQL DBA Lead

Responsibilities:

  • Provide prompt 7X24 on-call DBA support for mission critical applications
  • Administration and support MS SQLServer databases in a complex global datacenter environment
  • Good knowledge in install, upgrade and patching SQL and SQL Server
  • Build, Deploy and Maintain Uptime of SQL Server Servers
  • Manage SQL Server Production and Test Environments
  • Resolve Technical Issues as raised by the Customer and Technical Consulting Team
  • Coordinate the backfilling and refreshing of development environments between and releases
  • Preparing and reviewing complex change plans
  • Database Migration and Database Refresh
  • Regular Database Administration Activities
  • Installation and Remediation of SQL Server Cluster & Stand-alone Environment (2005 and 2008)
  • Setting up processes for regular backups and restore methods, and ensuring the processes are followed
  • Disaster Recovery Planning & Implementation
  • Installation of SQL Server 2008 R2. Upgrading SQL Server 2005 to SQL Server 2008
  • SQL Server performance monitoring and tuning
  • Writing RCA’s for recurring issues and Supporting CRT Call’s

Environment: Windows 2003/2008R2 Server, SQL Server 2005/2008/2008 R2

Confidential, New Brunswick, NJ

Production DBA

Responsibilities:

  • Installation and implementation SQL Server Fail-over cluster, on 32 and 64 Bit of SQL Server
  • Monitoring the Servers by accessing remotely and analyzing the databases sizes
  • High Availability setup and maintenance like Cluster, Replication, Log shipping and mirroring
  • Day to Day Production issues handling like end user and application user requests
  • Handling SQL Alerts, user requests and tickets
  • SQL Database migration from 2000/
  • Applying SQL Server patches and hot fixes
  • Refreshing the SQL Databases and Performance Tuning
  • High availability through Clustering, log-shipping, replication and disaster recovery strategies
  • Capacity planning for 2 node clusters that are designed to have highly available and provide fault tolerance
  • Migration/Moving database servers between different platforms/locations and setting up test, QA and production database environments
  • Installation of SQL Server 2005
  • Upgrading SQL Server 2000 to SQL Server 2005 either using in-place or side-by-side methods
  • Installing and managing SQL Server 2000/2005 fail-over clustering
  • Maximum size of the database 1.2 TB
  • Supporting approx. 100 SQL instances and approx. 1500 Databases
  • Configuring Mail setup in SQL Server 2000
  • Created and Maintained SQL Server 2005 SSIS Packages

Environment: Windows 2003 Server, Windows 2008 Server, Windows 2008 R2 and SQL Server 2005, 2008

Confidential

SQL Server Technical Lead

Responsibilities:

  • Production database administration of highly critical and large application databases
  • Active participation with customers in understanding their business process and suggesting optimal database structure
  • Setting up processes for regular backups and restore methods
  • High emphasis on database security, permissions, user management
  • Installing, upgrading and applying the latest service packs/hot fixes
  • Monitoring disk space utilization, CPU performance, I/O activities and automation of maintenance jobs using SQL Mail notification solutions
  • Fully understand the SLA commitment and meet the standards
  • Documentation of all the database maintenance and administration

Environment: Windows 2003 Server, Windows 2008 Server, Windows 2008 R2 and SQL Server 2005, 2008

Confidential

SQL Server DBA

Responsibilities:

  • Installation of SQL Servers
  • Creating and deploying the databases
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query
  • Analyzer to Administer SQL Server
  • Created Database Maintenance Planes for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing
  • Planned the Complete Backing up of Database and Restored the Database from disaster recovery
  • Planned and modified the permission issues in the server
  • Fine tuning of database objects and server
  • Data migration (import & export - BCP) from Text to SQL Server
  • Creating and maintaining DTS packages
  • Maintaining SQL Script for creation of Database Objects
  • Experience with DB Optimization

Environment: Windows 2003 Server and SQL Server 2005

Confidential

System Engineer

Responsibilities:

  • Installation and configuration Windows Server NT 4.0/2000 and MS SQL Server
  • Installation and Application Servers
  • Complete upgrading and administration of MS SQL 7.X/2000/ and WINTEL server
  • Installation and Configuration of Desktop applications and end user support
  • Crating user and granting permissions
  • Backup and restore SQL Databases
  • Applying OS and Database Patches and Hot fixes
  • General systems and Database support

Environment: Windows NT 4.0/2000 Server, SQL Server 7.0, 2000

We'd love your feedback!