SUMMARY

• 14+ years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers in Production, Test, Dev, Sandbox.
• Experience in designing Build process, Process Automation, Build and Deployment Automation, Release Management, Infrastructure automation with DevOps, Quality Control, Source Code repository & Environment management.
• Provided very good DR and HA Plans for end users,
• Infrastructure automation using Ansible.
• Created multiple VMs on AZURE Cloud Environments.
• Moved 1000+ databases and servers to Azure Cloud.
• Used monitoring tools like spotlight, foglight.
• Using Jenkins automated SSIS Deployments through Ansible.
• In - depth knowledge of computer applications and scripting like YAML.
• Automated infrastructure and application provisioning using Configuration management tools like Ansible.
• Highly skilled at improving the overall process as well as project operations while optimizing efficiency and reducing workload.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Servers and clusters.
• Experience in upgrading SQL Servers for all versions.
• Disasters recovery setup for sql servers like mirroring, always On, Replication.
• Performance Tuning (All Layers).
• Backup and restore, troubleshooting (Quick & Permanent).
• Working experience with Oracle JDE, and Oil and gas applications.
• Managing Distributed Database Servers.
• Hands on experience working with High Volume Databases, which sizes > 5 TB.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
• Extensive experience in writing Distributed Queries between SQL Servers by creating linked servers.
• Experience in implementing different types of Replication Models on basis of business specification.
• Good exposure writing TSQL queries, Stored Procs, Triggers, Functions, Constraints, and Indexes.
• Experience in performing integrity checks. Methods include configuring the databases.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.

TECHNICAL SKILLS

Operating Systems: Windows, Red hat Linux, Ubuntu

AWS and Azure: IAM,EC2,CloudFront,RDS,DynamoDB,Autoscaling,VPC,Cloudwatch,AWS CLI, AZURE CLI,S3,EFS,Virtual Machines, SQL DB,DMS,Data Lake

Languages: T-SQL, PL/SQL, C#, ASP .Net, VB.net, MVC .Net, CSS, VB Script, XSQL, Java Script, PowerShell, Python, CMD Shell and HTML

Report Tools: MS Reporting Services, Redshift

Tools: CA, SSMS, Remedy, Sibel

RDBMS: MS SQL Server, AWS and AZURE RDS

Data Migration: SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, FTP, SFTP, Batch Files, DMS, DMA

Database Modeling & Other Tools: Quest LightSpeed, Quest SQL fog light, Red gate SQL Compare, SQL Trace

CM and Containers: Ansible,Docker, Kubernetes

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL DBA/AZURE

Responsibilities:

• Creating multiple SQL servers on Iaas and paas environments
• Created multiple intermittent servers for migrations
• Backup and Restore activities on intermittent servers and cloud environments
• Moved 100+ databases from legacy systems to cloud
• Worked on SQL Server installation and configurations
• DR and HA setup for the new servers in Cloud environments
• Created multiple documents for the Migrations plan and cutovers
• Provided CRQ process for cutovers and backup plans
• Working automation for Azure using ansible
• Worked on Loading jobs for SAP

Confidential, San Ramon, CA

Sr SQL DBA/AZURE

Responsibilities:

• Create and drop databases on on-premises cloud environments
• Maintained security groups for audits
• Backup and Restore activities on cloud environments
• Moved 300+ databases from legacy systems to cloud
• Worked on load balancing, DNS, VPC, Kinesis for POC Projects
• Worked on AWS and AZURE storage systems with backup and copy
• Using Ansible created multiple playbooks for machine creations and SQL server, cluster server and my SQL installations
• Created multiple servers (Linux and windows) for POC work
• Setup bastion host for forensic environments
• Security group configurations and NAT instance creation, cloud watch metrics for POC work
• Setup a windows servers and Linux machines with SQL and my SQL installation for end users
• Worked on cloud formation templates for project deployments
• Created SQL Server always on cluster on AZURE cloud environment
• Setup geo replications for databases in AZURE
• Worked on cloud watch and Confidential monitor
• Worked on Transparent Data Encryption
• Installed Configured and Maintained deployments for SSRS 2008,2008r2 and 2012,2014,2016
• Maintained a stable process of database refresh from production to internal environments.
• Ensured the integrity and security and auditing the SQL Servers.
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non-production environments
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Participated in regular annual Disaster Recovery Activity and successfully recovered Databases.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.

Confidential

Lead SQL Server DBA

Responsibilities:

• Maintained a stable process of database refresh from production to internal environments.
• Installed Configured and Maintained deployments for SSRS 2008,2008r2 and 2012
• Responsible for Setup, configuration, maintenance of SQL Servers and their Mirroring.
• Databases creation for shared and dedicated servers.
• Ensured the integrity and security and auditing the SQL Servers.
• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries.
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Participated in regular annual Disaster Recovery Activity and successfully recovered Databases.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Created Linked Servers between SQL Server 2000, SQL Server 2008 and OLE DB data sources.
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.
• Creating and scheduling maintenance plans which include Database Backups database maintenance checks like shrink database, re-organizing and rebuilding of Indexes

Confidential

DBA / Venue Lead

Responsibilities:

• Worked as Venue Lead
• Supported for Reports
• Configurations for SSRS and SQL Server

Confidential

L3 Analyst /SQL DBA

Responsibilities:

• Participated in regular annual Disaster Recovery Activity and successfully recovered Databases.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.