Production Sql Dba Resume
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