SUMMARY:

* ***** ** ** ********** in Implementation, Administration and Support of MS SQL Server and PostgreSQL Databases.

Experience in System Analysis, Development & Support of MS SQL Servers 2000/ 2005/ 2008/ 2012/ 2014/ 2016/ 2017 in Production, Development, Testing and Data warehouse Environment.

Experience in working with Windows 2012R/2012/2008/2003/2000.

Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL Server Performance Alerts.

Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Extensive Experience in Database Backup, Recovery and Disaster Recovery procedures.

Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.

Designing of Security – Active Directory Groups, Roles, User.

Experience in Creating Databases based on Functional Requirement and System Design.

Experience in Performance Monitoring and Tuning, Query Optimization, Client/Server Connectivity, resolving Blocking /long running queries/ Dead Locks, Database consistency checks using DBCC Utilities.

Expert in implementing high availability features of SQL Server solutions, including Always ON, Log shipping, Replication, Mirroring and Cluster Environment.

Experience in Database Backup, Recovery and Disaster Recovery procedures in SQL SERVER and Design Tested and Implemented various Failure Strategies base on business requirements.

Deployed applications in AWS environment, including provisioning MySQL - RDS and established connectivity between EC2 instance and MySQL - RDS via security groups.

Create clusters in Google Cloud and manage the clusters using Kubernetes(k8s). Using Jenkins to deploy code to Google Cloud, create new namespaces, creating docker images and pushing them to container registry of Google Cloud.

Experienced in AWS Cloud IaaS platform with features EC2, VPC, ELB, Auto - Scaling, Security Groups, Route53, IAM, EBS, AMI, RDS, S3, SNS, SQS, CloudFormation, CloudFront and Direct Connect.

Maintain Database Authentication mode, creation of users, configuring permissions and assigning roles and Profiles.

Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, reviewing and recompiling stored procedures, Triggers, Data Consistency checks.

Creating and maintaining PostgreSQL databases on Linux, UNIX and Windows operating system environments.

Creating Postgresql schemas with along with custom tablespaces and assigning roles, privileges.

Implementing database backup and recovery strategies using all utilities like pg_dump, pg_dumpall, pg_basebakup etc.

PostgreSQL/SQL Server Applications Performance Tuning, Upgrading and Backup/Recovery of Postgres/MSSQL server Database, Vacuuming and other maintenance activities.

Experience in implementing different types of Replication models like Snapshot, Merge and Transactional in SQL Server. Logical and Streaming Replication in PostgreSQL.

Experienced in tuning the shared_memory, work_mem, maintenance_work_mem, areas, Buffer Cache, Rollback Segments, Redo/Undo Mechanisms, Monitoring and Detecting Locks/Latches, Wait Events, Contentions, and pinning frequently accessed objects.

Creating Postgresql schemas with along with custom tablespaces and assigning roles, privileges.

Experienced in implementing business logic by using TSQL, Stored procedures, triggers.

Experience in configuring and deploying SSIS packages across all environments.

Involved in mapping the tables from SQL server to MySQL through workbench for migrating the data to MySQL databases.

Involved in data clean-up of SQL server databases before migrating.

Created, configured and ensured connection to RDS database running on MySQL and SQL engines.

Knowledge on Databases like Cassandra, MySQL.

Experience with other 2005 new concepts like DMV’S, DMF’S, and performance dashboard.

Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and expert in tuning Complex Queries.

Experienced in Azure Cloud PaaS Databases (Azure SQL, Azure DB for PostgreSQL)

Strong Knowledge of Migration from On-prem to Azure Cloud using native backup restore and DMS Services.

Optimum Utilization of Operating System Resource to SQL Server.

Involved in design of SQL triggers, and correcting database errors.

Experience in Logical and Physical Database Design and Capacity Planning.

Strong Understanding of DevOps Procedures including Cloud Architecture in AWS and Azure.

Migrate On-Premise PostgreSQL and SQL Server databases to Azure DB for PostgreSQL (PaaS), Azure SQL Database (PASS) and Azure SQL VM (IASS).

Strong Understanding of Scripting Languages like PowerShell, Python.

Proficient in Linux/Unix/Ubuntu platforms including ssh’ing across various

platforms in a network.

Experience in providing Production Support for 24x7 Environments.

Documenting all the Standard Procedures.

TECHNICAL SKILLS:

Operating System

Windows Server 2000/2003/2008/2012

Databases

SQL Server 2000/2005/2008/2012, 2014, 2016, Microsoft Access, ORACLE (8i/9i/10g), AWS RDS, PostgreSQL, Azure DB for PostgreSQL, Azure SQL, Azure DB for MySQL.

Languages

T- SQL, PlpgSQL, SQL Plus, PL/SQL, Python

Programming/ Scripting

PowerShell Script, XML, HTML, DHTML, T-SQL Programming, VB 6, C++, JAVA, .Net, C#.

Database Tools

Management Studio, Enterprise Manager\Grid Control, Query Analyzer, DTS, BCP, Data Pump, Erwin, Visual Source Safe(VSS), VSTS 2010, WinScp, Putty, SQL Sentry, SQL Profiler, Toad, SQL Developer, Attunity Replicate, Vormetric Encryption, PgAnalyze, PgBouncer.

Backup Tools

Control-M, SCOM, MOM, Embarcadero, LiteSpeed, Spotlight, Remedy Service Center Desk, SharePoint Server, Microsoft Hyper-V, BMC Patrol, Red gate Backup Tools, Active Directory, Wintel, Legato Tape Backups

Monitoring Tools:

Solar Winds, App Dynamics, Splunk.

EXPERIENCE SUMMARY:

Boeing, Seattle April 2018- June 2020

Sr. SQL SERVER DBA

Responsibilities:

Installed and configured SQL Server 2012/ 2014/ 2016 on production and non-production servers.

Migrated databases from SQL Server 2008 to SQL Server 2012/ 2014/ 2016 as part of Data Center migration.

Worked on google cloud platform (GCP) services like compute engine, cloud load balancing, cloud storage, cloud SQL, stack driver monitoring and cloud deployment manager.

Experience in building and configuring VMs, databases in GCP Infrastructure.

Reconciliation of data between source system and target system (GCP).

Experience in SQL coding and SQL performance tuning in GCP.

Experience in scheduling jobs using cloud scheduler in GCP.

Setup GCP Firewall rules to allow or deny traffic to and from the VM's instances based on specified configuration and used GCP cloud CDN (content delivery network) to deliver content from GCP cache locations drastically improving user experience and latency.

Worked on Attunity to implement Change data Capture and to obtain real time data integration.

Expertise in Always-On Availability Groups (HAAG) and DR Troubleshooting.

Created Shared storage, created machine user names to resolve configuration issues in Always-On availability setup.

Implemented Always-On Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.

Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.

Setting up custom Reports using SQL Server Reporting Services (SSRS) tools for providing information to Client Services Managers

Experienced in extracting data from Development / UAT / Production servers by using SSIS.

Provide database coding to support business applications using T-SQL, Experienced with Clustering setup and Active Directory in Windows 2010.

Experienced in Database Consistency Checks – DBCC Commands for database maintenance.

Modified Stored Procedures and complex T-SQL Queries to improve query execution process.

Used SQL Profiler, Server-side trace to identify performance issues on the server.

Created Jobs and maintenance plans for better performance of the server.

Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands.

Used Tableau Admin views to identify the performance issues on the Tableau workbooks.

Worked on TFS and brought all the servers under Source control.

Managed server logins, database users and permissions.

Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner.

Setting up Encryption using Vormetric Encryption.

Created Maintenance Plans that helped in effective disk utilization and index maintenance.

Effectively managed disk space using LITE SPEED for Data Base Backups

Worked on VLDB’s ( 20 TB)

Worked on SQL Server monitoring tools DPA (Solar winds) for SQL server performance

analyzer and maintaining like Query tuning, blocking, wait types, CPU, Memory and I/O utilization.

Monitored Database Slowness using third party monitoring tools like App Dynamics and Splunk.

Worked in 24/7 Production Environment.

Environment: SQL Server 2008/ 2012/ 2014/ 2016, Windows server 2008/2012, T-SQL, SQL Profiler, Performance Monitor, LiteSpeed, Attunity Replicate, SSRS, SSIS, DPA Solar Winds, App Dynamics, Splunk, PowerBI.

Merck, NJ Dec 2016 – March 2018

SQL SERVER & PostgreSQL DBA

Responsibilities:

Installing and Configuring Microsoft SQL Server enterprise edition on development, pre-production and production servers.

Monitoring and Performance Tuning of Sql Server, Operating System.

Implementing High Availability feature like Always ON, Log Shipping, Mirroring for Disaster Recovery.

Successfully implemented AlwaysON Availability group in SQL 2012 and installed SQL server in a cluster Environment.

Created several SQL Server objects like Tables, Views, Queries, Stored Procedures, Functions, triggers and Indexes.

Implementing Backup and Recovery Strategies based on Business requirements.

Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL Server Performance Alerts.

Migrated SQL server between different versions.

Creating and Scheduling PowerShell reports on non-prod environment and helping developers to write T-SQL scripts.

Using Performance Monitor/Sql Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance.

Health Check PowerShell Reports on daily basis for complex 40+ production database server (100+ production databases) environment.

Designing of Security – Active Directory Groups, Roles, User.

Managed Security using SQL Logins, Permission, Roles and Security Modes as a part of Security Policies for various categories of users.

Controlled and coordinated the installation of Security Patches and Service Packs.

Creating and maintaining PostgreSQL databases based on requirements.

Analyzing SQL statements using Explain Plan or views and performing health checks of the DB.

Supporting Very Large Databases VLDB.

Reviewing T-SQL code to verify and meets standards for both performance and error handling according to DBA standards.

Working Extensively on Disk Space Utilization and Capacity Planning of Postgres and SQL Server DB’s.

Migrated On-prem PostgreSQL and SQL Server to Azure SQL and Azure DB for PostgreSQL using Azure DMS (Database Migration Service)

Monitoring Azure SQL and PostgreSQL databases by enabling Query Store on Azure Portal.

Worked in writing Stored Procedures, Functions and Triggers using T- SQL and expert in tuning Complex Queries.

Identifying bottle-necks of the database such as locks, latches, and wait events & Investigating fragmentation, root cause for instance slow down etc.

Supporting 24/7 Production Environment

Documenting the Standard Procedures.

ENVIRONMENT: MS SQL Server 2005/2008/2012/2016, PostgreSQL, Azure SQL, Azure DB for PostgreSQL, T-SQL,SQL Profiler, Performance Monitor, Red Gate, Embarcadero, AWS RDS, VSTS 2008,Clustered Environment, My Services, HP Service Manager, Power BI.

Wells Fargo, AZ May 2015- Nov 2016

SQL SERVER DBA

Responsibilities:

• Migrated DTS packages to SSIS Packages and upgraded SSIS packages from SQL 2005/2008 R2 to SQL Server 2012.

• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.

• Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).

• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability.

• Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.

• Used Tableau Admin views to identify the performance issues on the Tableau workbooks.

• Implemented Transactional and Snapshot Replication in SQL 2008 R2.

• Created Shared storage, created machine usernames to resolve configuration issues in Always On

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

• Proposed Kronos upgrade project to Client including SQL server upgrade.

• Experienced in extracting data from Development / UAT / Production servers by using SSIS.

• Provide database coding to support business applications using T-SQL, Experienced with Clustering setup and Active Directory in Windows 2010.

• Develop new processes to facilitate import and normalization, including data file for counter parties.

• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.

• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.

• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

• Supported 24X7 in production issues and User's issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2012 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Navayuga Infotech, India. May 2013- Dec 2013

SQL Server DBA

Responsibilities

Installed and Configure Microsoft SQL Server enterprise edition on development, pre-production and production servers. Experience working in clustered environment and upgraded SQL 2000/2005 to SQL 2008/2012 in both non-clustered and clustered environments. Closely work with application teams to resolve the issues that are outcome of major SQL upgrade.

Trouble Shooting and Solving the Production issue’s.

Monitoring and Performance Tuning of SQL Server, Operating System, SSIS and SSRS.

Implemented Backup and Recovery Strategies base on Business requirements

Implemented High Availability feature like Log Shipping, Mirroring for Disaster Recovery

Used Performance Monitor/SQL Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance

Created and maintained Automation of Database Maintenance Plans for the Performance of servers which covers Database Integrity Checks, Update Database Statistics and Reindexing.

Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.

Supporting Development/Testing/ Data warehousing/ Sysadmin Teams.

Experience Working in SharePoint.

Installation, configuration, administration, backup/restore, SQL Security, Jobs, Mirroring, Log Shipping.

Transferred data (ETL) to Data ware house Environment using SSIS.

Supported Very Large Databases VLDB (Max Size-1.2TB)

Worked extensive with database design team and development team for database design and implementation, used Erwin for database design and SQL 2008 for development.

Review T-SQL code to verify and meets standards for both performance and error handling according to DBA standards

Capacity Planning and Optimizing the sizes of Databases

Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.

Reviewing Multi-Server System Info and utilizing the hardware at its best

Worked Extensively on Disk Space Utilization and Capacity Planning

Created and Manage Custom Application Jobs according to Application requirements Supporting 24/7 Production Environment

Documenting the Standard Procedures

Actively Participated in meetings, recommended the necessary changes required in present database or business systems.

ENVIRONMENT: MS SQL Server 2005/2008/2012, Windows 2000/2003/2008 Server, T-SQL, SQL Profiler, Performance Monitor, Red Gate, HP Services Toad 8.0. ASP.Net, VB.Net, ADO.Net, COM, XML.

Contact this candidate