PROFESSIONAL SUMMARY:

• IT professional with more than 12+ years of experience in Design, Deployment and Administration of SQL Server databases for OLTP and OLAP environments.
• Expertise in installation, maintenance and support of SQL Servers databases for applications in large - scale environments.
• Expert in writing T-SQL, including complex stored procedures, functions, views and triggers.
• Experience with database design development life cycle including Requirements phase, Analysis phase, and Conceptual design phase, Implementation design phase and Physical implementation phases.
• Familiar with database design techniques such as Normalization and De-Normalization, and Data Modeling tools like ER-Win.
• Experience in configuring and implementing database level and server level security.
• Proficient with Backup and Recovery strategies.
• Experience in performing database upgrades and migrations, and installation of SQL Server service packs and security hotfixes.
• Experience with High Availability and Disaster Recovery solutions in SQL Server, including Database Mirroring, Log Shipping, Replication, Failover Cluster, AlwaysOn.
• Experience in database performance tuning and query optimization using native tools such as SQL Server Profiler, System Monitor, Database Tuning Advisor, Activity Monitor and Third-party monitoring tools including Idera and SolarWinds.
• Experience with SQL Database implementation using AWS Services (EC2 and RDS).
• Expert in scripting languages including PowerShell and T-SQL.
• Experience with ETL tools including SSIS, SSRS and SSAS.
• Used Visual Studio SQL Server Data Tools to troubleshoot and debug SSIS Package issues.
• Ability to work independently with minimal supervision in fast-paced environments.
• Possess strong analytical and problem-solving skills.

TECHNICAL SKILLS:

RDBMS: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analytical Services (SSAS).

Scripting Languages: T-SQL, PowerShell

Monitoring: Idera

Operating Systems: Windows Server 2003/2008/2012/2012 R2/ 2016, Linux 5/6/7

Project Management: MS Project 2010/2013/2016 , Scrummage, Waterfall, MS Excel.

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator

Confidential

Responsibilities:

• Installed and upgraded SQL Server instances from 2012 and .
• Constantly review Idera Monitoring tool for SQL Server to improve performance and better utilization of SQL resources (Disk/Memory/CPU/ IO).
• Controlled review and deployment of database changes in Production/QA/Prod-Parallel.
• Regularly monitoring capacity requirements for backups and storage requirements.
• Responsible for SSRS/SSIS/SSAS deployments and debugging issues.
• Work with SQL tools such as Query Analyzer and SQL Profiler to resolve day to day issues in SQL Server.
• Responsible for database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery of SQL Server operational databases for enterprise software provisioning application.
• Proactively monitor databases for performance issues such as duplicate indexes, unused indexes, etc.
• Developed and implemented database policies and procedures to ensure integrity and availability of database and application.
• Manage and troubleshoot all SQL Agent Jobs including that are created for Maintenance plans.
• Analyzed and resolved capacity, performance and security needs for database server infrastructure.
• Create automation and monitoring scripts using PowerShell and T-SQL.
• Implemented High Availability and Disaster Recovery strategies using AlwaysOn Availability Groups and Replication.
• Written complex queries, stored procedures and views using T-SQL whenever required for managing, troubleshooting and debugging.
• Installed and upgraded databases by applying patches and updates on a regular schedule.
• Provided technical support to application development teams.
• Responsible for managing database security according to published policies.

Database Administrator

Confidential

Responsibilities:

• Installed, configured and managed SQL Server databases for Third-party Lab Automation software in AWS.
• Migrated Pervasive SQL databases to SQL Server 2012 databases.
• Configured and implemented SSRS reports for third-party safety observations and equipment inspection software and used Report Builder 3.0 to generate ad-hoc reports and managed reports access.
• Used SSAS to create cubes from OLAP databases and maintained.
• Used SSIS packages to move data from OLTP databases into OLAP databases.
• Installed, configured and managed Master Data Services for Master Data Management of critical data of client organization.
• Responsible for controlled deployment of updates, patches, hot fixes to production environment.
• Implemented session-based desktop deployment (Publish RemoteApp) using Windows Remote Desktop Services.
• Used CommVault to manage SQL Server database backup and recovery.
• Installed and configured database monitoring tool SolarWinds to identify and troubleshoot performance issues.
• Documented SQL Server instances and managed Run books to provide operational documentation for the maintenance.

Database Administrator

Confidential

Responsibilities:

• Responsible for database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL Server databases for insurance application (Policy Management System), payroll processing application and invoice processing application.
• Responsible for designing proof of concept (POC) HA/DR solutions using AlwaysOn, Failover Clustering, Database Mirroring, Replication and Log Shipping.
• Responsible for creating baseline for SQL Server using native tools including SQL Server Profiler, Extended Events and Performance Monitor.
• Responsible for designing and scheduling SSIS packages to move data from transactional databases to data into data warehouses.
• Responsible for database deployment and releases management using TFS.
• Responsible for designing reports using Report Builder 3.0 and managing permissions on reports.
• Performed controlled migrations, upgrades, hotfixes and patch updates on database servers and application servers.
• Analyzed, identified and resolved capacity, performance and security needs for database server infrastructure.
• Participated in database design development life cycle of databases with database development teams.
• Responsible for performance tuning of databases to investigate and troubleshoot CPU pressure, Memory pressure, Disk I/O bottlenecks, Network and Slow performing queries.
• Performed Index Maintenance and updated statistics to improve SQL Server performance.
• Used Tivoli Storage Manager to manage SQL Server database backup and recovery.

Confidential

Database Administrator

Responsibilities:

• Responsible for database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery of SQL Server operational databases for enterprise software provisioning application.
• Developed and implemented database policies and procedures to ensure integrity and availability of database and application.
• Analyzed and resolved capacity, performance and security needs for database server infrastructure.
• Implemented High Availability and Disaster Recovery strategies using Replication, Failover clustering, Database Mirroring, Log Shipping.
• Installed and upgraded databases by applying patches and updates on a regular schedule.
• Provided technical support to application development teams.
• Regularly monitored and tuned databases using native tools including SQL Server Profiler, System Monitor, Activity Monitor and Database Tuning Advisor.
• Responsible for managing database security according to published policies.

Confidential

Jr. Database Administrator

Responsibilities:

• Installed, Configured and managed SQL Server operational databases for e-learning platform.
• Regularly monitored and tuned databases using native tools including SQL Server Profiler, System Monitor, Activity Monitor and Database Tuning Advisor.
• Implemented Log shipping and Database Mirroring as High Availability and Disaster Recovery strategies.
• Involved in database development life cycle for database design.
• Provide input to Development organization or Software Engineers on (possible) updates that are needed to ensure product or solution quality.
• Work with customers to verify fixes supplied have resolved their problems.
• Escalate customer issues to Software Engineer, Senior Technical Support Specialist, Senior Technical Support Rep, Team Lead, or support management.
• Performed problem recreations and bug verifications.
• Performed QA testing on upcoming releases to learn new features and functions.

Confidential

Pre-Sales Engineer

Responsibilities:

• Conduct Sales Presentations
• Develop Sales Proposals
• Provide Technical Sales Support
• Prepare and present product demonstrations
• Identify, evaluate, and recommend proof of concept opportunities
• Prepare and provide input for technical sections of RFPs/ RFQs
• Communicate with Engineering on issues identified from field observations and customer feedback