SUMMARY

• 15+ years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2016,2014, 2012, R2, 2008, 2005 and 2000 in Production, QA, Reporting, Staging, UAT, Development, Replication and Clustered Server Environments.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2016/2014/2012/ R2/08.
• Experience in upgrading SQL Server from version /R 2/2012/2014/2016.
• Have good experience with partitioned schemas, partitioned tables and indexes, creating file groups using SQL Server 2008/2012/2014/2016.
• Good experience with implementing DR solution, High Availability of database servers using Database Mirroring, Replication and Log Shipping, Always on.
• Experience in Data Migration Management and Maintaining Large Data Sets.
• Hands on experience working with High Volume Databases which sizes > 5 TB.
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• 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 like Snapshot, Merge and Transactional on basis of business specification.
• Good exposure writing TSQL queries, Stored Procs, Triggers, Functions, Constraints, Indexes, Performance Tuning, Capacity Planning, Power Shell scripts for monitoring.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003/2008/2012 Server, Windows 95/98/XP/NT/7/10

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

Report Tools: MS Reporting Services

Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2010, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Database Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), Active Directory, Active Server Roles, CA Service Desk, IT Service Catalog, Team Track, VMWare, Connect wise, SQL Safe, Remedy, SSDT, HP Overview etc.

RDBMS: MS SQL Server 2005/2008/R2/2012/2014, MySQL, Oracle

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

Database Modeling & Other Tools: Quest LightSpeed, Quest SQL Spotlight, Red gate SQL Compare, SQL Trace, SCOM 2012

Cloud: Aws,Azure

CM Tools and other tools: Ansible,Kubernetes,Dockers,Jenkins,Github

PROFESSIONAL EXPERIENCE

Confidential, San Ramon

SQL Server DBA /Architect/Developer

Responsibilities:

• Maintained a stable process of database refresh from production to internal environments.
• Installed Configured and Maintained deployments for SSRS 2008,2008r2 and 2012,2014,2016
• 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.
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
• 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.
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.
• Created Linked Servers between SQL Server 2000, SQL Server 2008 and OLE DB data sources.
• Creating and scheduling maintenance plans which include Database Backups database maintenance checks like shrink database, re-organizing and rebuilding of Indexes
• Designed databases for different projects and resolved Database issues.
• Managing security tasks like granting and revoking permissions.
• Data comparison using red gate tools
• Running DBCC Consistency Checks and fixing Data Corruption in user databases.

Confidential

Sr SQL Server DBA / Developer

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.
• Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
• 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.
• Maintained change control and release management process for all database objects like tables, views, procedures, and triggers.
• 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

Senior 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.

Confidential

SQL Server DBA

Responsibilities:

• Databases creations
• Data loading from Paradox to SQL to Oracle
• Alert Monitoring
• Backup and restore

Confidential

SQL Server DBA/.net Developer

Responsibilities:

• Supported for SQL Server installation
• Production support