SUMMARY

• An accomplished IT Professional with 9+ years of experience as a Database Administrator of which 6+ years on SQL Server Database and 2+ years on Oracle Database.
• Proficient in Installation, Design, Development, Implementation, and Administration of databases. Also, vast experience in code migration, database warehousing and database change management through the various stages of the development life cycle of SQL Server Database.
• Hard - working and dedicated team player willing to collaborate with co-workers to fix problems and complete projects in a timely manner with excellent communication skills.

AREAS OF EXPERTISE

• Database Modelling
• Querying
• Database Installation & Upgrade
• • Strong Desire to Learn
• Database Mirroring
• Documentation
• Backup and Restore
• Decision Making
• Database Disaster Recovery
• Troubleshooting skills
• Dynamic Management Views & Functions
• Adaptability

TECHNICAL SKILLS

Databases: SQL Server 2017/ 2016/2014/2012/2008 / R2/2005/2000, Oracle 11g/10g/9i/8i

Programming Languages: T-SQL, SQL+, PERL, PowerShell, PL SQL, HTML, VBScripts, XML

Operating Systems: Microsoft Windows XP/NT/2007, Windows 10

Hardware: Net Apps Storage, EMC Storage, HP Server

Database Tools & Reporting: SQL Management Studio, SQL DB Access, Performance Monitor, Backup UtilitySQL Lite Speed, ERWIN, DB Artisan, Spot light, Toad for Oracle, Idera tools, SQL developer, ignite (solar winds DPA), SQL Reporting Services, Tableau

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr SQL Server DBA

Responsibilities:

• Installed, Configured and upgraded SQL Server Databases (2012, 2016 & 2017)
• Handled Clients production MSSQL Databases and maintaining High Availability like AlwaysOn AG, Replication, Mirroring and Clustering.
• Migrated and Maintained DBs from MSSQL on Premises to SQL Azure, PostgreSQL, VMWare Cloud on AWS
• Setting MSSQL DB High availability and DR Solutions using AlwaysOn, Replication, Log Shipping and Mirroring.
• Setting AWS PostgreSQL DB High availability using Amazon Aurora Cluster.
• Performed Database maintenance activities like Backups, Restoring, and Re-indexing etc.
• Handled Data Warehouse & Analytics Databases performance issues.
• Provided Level3/4 Support for E-Business Suite & Database issues
• Applying Cumulative, Mini, Bug Patches & Performing Upgrades.
• Implemented Disaster Recovery / standby database using Oracle Data Guard.
• Consolidated Database environment migrating to GRID Environment reducing server and license count.
• Provided management with comprehensive reports which helps in decision-making, Capacity Planning, etc. and are SAN Storage Utilization, DB Growth, Backups & Systems Performance, etc.
• Designed storage requirements as per best practice & work load type

Confidential, Lincolnshire, IL

Sr SQL Server DBA

Responsibilities:

• Installed, managed and administrated MS SQL Server 2016/2014/2012/2008 R2/2008/2005 Production and Non-Production Servers.
• Migrated scripts in a production environment and extensive experience in creating and modifying stored procedures, triggers, cursors and functions to meet business requirements.
• Expertise in implementing different types of high availability and disaster recovery mechanism like replication models, log shipping, database mirroring, always on and clustering.
• Worked on Clustering and server consolidation, troubleshooting production issues and raising high availability.
• Worked with SQL monitoring tools - Red Gate; SQL Sentry
• Set up SQL server Clustering and Always On technology
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
• Worked on Installation of MSSQL Server Module on Production and Non-Production Servers.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production server. Azure SQL

Confidential, Houston, TX

Sr SQL Server DBA

Responsibilities:

• Installed & Configured SQL Server 2016/2014/2012/2008 R 2/2008/2005 64/32 bit versions on Windows 2012/2008/2003 R2 64/32-bit servers on Enterprise systems. Both on Windows Physical servers and Virtual Servers.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Engineered and implemented a database design to consolidate number of database instances.
• Reviewing and Deploying SQL changes as per the software development life cycle
• Created email alerts with the reports of daily backups, maintenance jobs and security checks.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Automating Database Backups of various user databases per the requirement.
• Implemented Windows/ SQL Authentication scheme per the application requirement.
• Involved in various Audit meetings both internal and external auditors.
• Implemented SQL Server replication to accommodate the reporting functionality on an OLTP system.
• Responsible for routine DBA jobs such as Backups and Restores.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Created database snapshots before a deployment to ensure the changes are rolled back without compromising the time of availability in case of errors.
• Performed basic DBA tasks such as monitoring, user management, permission management, creating database objects in depth knowledge and practical experience of implementing MSSQL HA/DR/Maintenance/Backup/Monitoring/Data Archiving strategies

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• SQL Server 2008 R2/2012Database Administration/Development.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs, SQL Azure, Aws.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Worked with a team for data access programming, physical database design, and implementation of Microsoft SQL Server.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Database Analysis of each database which is part of old or unsupported Hardware and software.
• Documented and Maintained the database instances across the environment and worked with the procurement to allocate appropriate licensing to all the servers
• Engineered and implemented a database design to consolidate number of database instances.
• Datacenter Migration with SQL Server upgrades.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build
• Worked with a team responsible for the 24x7 support of Microsoft SQL Server databases.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Worked in Active, Active Passive Cluster environment as a High availability solution. With SQL Azure
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Worked on Security and troubleshooting.
• Designed and developed data models for new applications.
• Upgraded the database from oracle 9i to 10g using DBUA, export/import utilities.
• Migrated SQL Server SSIS packages from SQL 2005/2008/2012 to SQL 2008/2012/2014 with effective planning.

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

• Designed and developed Asset tracker application including requirement gathering
• Upgraded SQL server 2000/ 2005/2008/2012 to SQL Server 2012/2008 R 2/ 2008/2012/2014/2016 on Operating Systems Windows Server 2003 R2/ 2008 R2/2012
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Strategically invested in tools to minimize the storage costs along with the time taken for running backup jobs.
• Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
• Automating Database Backups of various user databases per the requirement.
• Automated refreshes from production to development database on a regular basis using PowerShell.
• Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.
• Involved in Source Data Analysis and designing mappings for data extraction
• Implemented Replication and Log Shipping to overcome Disaster Recovery Plan.
• Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Upgraded and redesigned several DTS/SSIS packages, SSRS RDL files.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.