Sr. Sql Database Administrator Resume
Lawrenceville, NJ
SUMMARY
- Goal oriented Database Administrator with proven technical leadership and project management skills with experience in a high - profile and challenging corporate environment.
- I have extensively worked with key business and operation stake holders, compliance, internal audit and regulators throughout the career. Also experience in architecting and designing strategic enterprise-wide technology solutions.
- Extensively worked on SQL Server database Administrator, in with hands-on experience in installing, configuring, managing, monitoring, migrating and applying SQL Service Pack and troubleshooting SQL Server / 2008 R / 2016 instances in Prod, UAT, Test and Dev environments
- Practice with implementing, configuring and troubleshooting in Standalone, Windows Active-Active and Active-Passive Clustering, Backup/Recovery, SQL Server Security, Replication, Log shipping, Mirroring and SQL server 2012/2014 AlwaysOn failover High Availability and Disaster Recovery solutions
- Knowledge in various ETL, Reporting and strong SQL coding skills with SSIS and SSRS
- Constantly involved in SQL Server T-SQL in construction in Triggers, Tables, Store Procedure, User Defined Functions, Views, Indexes, relational databases models, and data integrity.
- Investigated and resolved the critical issues of significance including Query Performance Tuning and cpu, memory, io bottleneck issues
- Provided technical support for various databases and applications to assure full operational conditions 24/7
- Solid understanding of Azure SQL db and cloud computing service models (IaaS,PaaS,SaaS) and proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth
- Created public, private & hybrid clouds based upon Microsoft Azure technology with special emphasis on Microsoft Azure PaaS offerings covering compute, Storage, Networking, middleware, API management etc.
- Expertise in creating large on-premise to Cloud Migration plans for VM’ Confidential & applications along with creating a large BCDR plans over the cloud.
- Implemented large HA/DR Azure Cloud (Private & Public) environments for mission critical applications using Express route and 24x7 monitoring using Microsoft Azure monitoring solution.
- Familiarity with IGNITE8, Red gate SQL Data Compare 10, SQL Backup7, Share Point, DB Artisan 7.2, 8.1.5, BMC. IDERA SQL Diagnostic Manager
TECHNICAL SKILLS
RDBMS: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Sybase 11.0, 12.5, MySQL and Oracle
Cloud: Microsoft Azure Cloud Computing Platform & Services
Software: T-SQL, SQL, PL/SQL, IDERA SQL Diagnostic Manager, Solarwinds DPA, Red Gate SQL Backup7, Share Point, DB Artisan 7.2, BMC, SSIS, DTS. SSRS, Crystal Reports, Access, Performance Tuning, Capacity Planning, ODBC, JDBC, OLEDB, DTS, SSIS, SSRS
OS: Win 2012/2008/2003/2000 Server/Windows 2000 Professional/ UNIX (Sun Solaris), Red Hat Linux
Language: Windows Power shell, C+, COM+, Visual C++, .Net, HTML, SML, ASP, JSP, JavaScript, VB.
PROFESSIONAL EXPERIENCE
Confidential, Lawrenceville, NJ
Sr. SQL Database Administrator
Responsibilities:
- Hands on experience in Install, Upgrade, Migration, Performance Tuning, Patching in all SQL Server 2008/2008R2, SQL2012/2014 and SQL Server 2016 etc.
- Troubleshot day-to-day problems encountered on production databases and custom application issues
- Provided Expert level services as core SQL DBA, performance Tuning and backup/recovery
- Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
- Used DMV, SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code and third party software DPA (Ignite8)
- Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
- Maintained a stable process of database refresh from production to internal servers.
- Involved in CDC (change data capture) and CT (change tracking) process.
- Configuration and troubleshooting of Always-on availability on SQL server 2012/2014 and 2016
- Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
- Proficient with infrastructure automation techniques using PowerShell
- Provided strategic direction for the database team and functioned as the technical/project leader on projects.
- Used several azure cloud service models (IaaS, PaaS,SaaS) and proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth.
- In-depth knowledge and experience with creating websites, Virtual machines in Windows & linux, SQL Databases, Resource groups, alerts, creating Availability sets per company SLA etc.
- Solid Knowledge and hands-on experience with Microsoft Azure (compute, data management, identity & access, mobile services, backup, messaging & integration, networking, storage, monitoring, custom apps, security etc.)
- Migrating On-premises SQL databases to Azure cloud VM and Azure SQL
- Configured and implemented detailed monitoring of the MS Azure cloud networks, monitoring all the different fabric of Azure.
- Implemented a Hybrid Cloud Solution in Azure to achieve a cloud-integrated solution
- Created public, private & hybrid clouds based upon Microsoft Azure technology for JRI America in different continents.
Confidential, North Brunswick, NJ
Sr. SQL Database Administrator
Responsibilities:
- Maintained a stable process of database refresh from production to internal
- 24 x 7 Production Support
- Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
- Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries using SQL DMV and third party software IDERA SQL Diagnostic Manager.
- Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
- Worked on Virtual Servers.
- Involved in CDC (change data capture) and CT (change tracking) process.
- Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
- Configuration of Log shipping and Replication
- Experience with PowerShell Scripting
- Configuration of Mirroring (Synchronous &Asynchronous)
- Provided strategic direction for the database team and functioned as the technical/project leader on projects.
- Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
- Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing
- Maintained a stable process of database refresh from production to internal
- Involved in CDC (change data capture) and CT (change tracking) process.
- Configuration and troubleshooting of Always-on availability
Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, TSQL, RED GATE, AlwaysON, Mirroring, Clustering and Log Shipping
Confidential, Mt. Laurel, NJ
SQL Server Database Administrator
Responsibilities:
- Created and managed multiple databases and assisted in capacity planning
- Monitored, maintained database systems and troubleshoot problems that may arise
- Maintained data integrity and security (managed roles and permissions of database users)
- Use tools like SQL Profiler for database tuning
- Generate traces,execution plans, identify performance issues, deadlocks/contention and resolve them
- Developed strategies and implemented solutions for managing back-ups, restoration and replication
- Created and managed constraints and indexes
- Supported software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures
- Created detailed documentation including diagrams of database infrastructure
- Learn relevant business processes and understand the data flow,critically and dependencies
- Effectively coordinated and communicated with all the stakeholders
- Set up and maintained database infrastructure for the company’ Confidential Power BI needs
Confidential, New York, NY
Production SQL Server DBA
Responsibilities:
- Perform level III incident on call 24X7 support and troubleshot day-to-day problems encountered on production databases and custom application issues
- Implement and troubleshoot in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performances Monitor and built in performance reports in SSMS, Query Plans, and Database Tuning Advisor
- Responsible for applying service pack and hot fix to all version of SQL Server
- Implement and maintain databases, perform software installations and upgrades, monitor database performance, perform capacity planning and SQL Server clustering, and manage database Quality Assurance including database consistency check
- Used PowerShell to automate admin tasks.
- Designing, implementing, maintaining, and generating daily report to monitor backup job for all SQL Servers
- Manage MSSQL Server (storage, memory, processing) and their dependencies and performance bottlenecks
- Responsible for maintaining database security, and high availability such as transactional replication, SQL Clustering, Log shipping
- Review/apply Stored Procedures, Triggers, and other TSQL code developed by developers
- Monitored and ensured Disaster Recovery for critical database
- Ensured developers coordinated their efforts in managing and maintaining different application databases
- Manage the granting of access to testing, development application and system databases
- Implement various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications
Environment: SQL Server 2000/ 2005/2008/2008 R2/2012/2014
Confidential, New York, NY
Production SQL Server DBA
Responsibilities:
- Provided 24/7 support to SQL Server Production serves (MS dynamics financial systems) and Production Historical server for analytics systems
- Evaluated database performance and performed databases, perform software installations and upgrades, monitor database performance, perform capacity planning and SQL Server clustering, and manage database quality assurance including database consistency check. The project migrated SQL Server 2005 to SQL server 2008 and SQL Server 2008 R2
- Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained required level of security for all production and tested databases
- Extensive experience in SQL Query Performance tuning by Using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, built in performance reports in SSMS, Query Plans, and Database Tuning Advisor to optimize the queries and enhance the performance of database servers for SQL Query Performance tuning
- Managed the granting of access to testing, development application and system databases
- Created and managed schema objects such as Tables, Views, Stored Procedures, Triggers to handle complex business rules, history data and audit analysis
Environment: SQL Server 2000/ 2005/2008/2008 R2
Confidential, Hartford, CT
Production SQL Server DBA
Responsibilities:
- Maintained databases, performed software installations and upgrades, monitored database performances, performed capacity planning and SQL Server clustering, and managed database quality assurance including database consistency check
- Implemented various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications
- Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation
- Performing backup and recovery tasks and restoring databases (when database is moved from one environment to other or database is crashed and needs manual recovery)
- Provided 24X7 supports to SQL application developers on production servers
Confidential, Brooklyn, NY
Production MS SQL Server DBA
Responsibilities:
- Provided 24X7 supports for Database administration, deployments/upgrades, DR, patching
- Performed performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor)
- Implemented custom Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup)
- Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
- Responsible for installing SQL Server on the new build Standalone and Clustered servers
- Disaster Recovery for critical database with compliance for HIPPA
- Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained required level of security for all production and tested databases
- Migrated DTS packages in SQL Server 2000 to SSIS of SQL Server 2005
- Environment: SQL Server 6.5/7.0/2000/ 2005/2008/2008 R2
