Sql Server Microsoft

Srikanth

**************.******@*****.*** 302-***-****

PROFILE:

Overall, 13 years of Microsoft SQL Database Administration, 4 Years of PostgreSQL progressive experience in administering, developing, and optimizing Microsoft SQL Server and PostgreSQL environments across on-premises and cloud platforms.

Proven expertise in SQL Server architecture, performance tuning, high availability solutions, disaster recovery, migration(on-perm/cloud). Adept in driving automation, ensuring data integrity, and aligning SQL solutions with business-critical needs in enterprise settings.

SUMMARY

Experience in installation/configuration/upgrading/migrating/administering MS SQL Server in Production, UAT, QA and Development (on-prem and cloud based).

Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.

Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Extensively worked on Active-Active and Active-Passive Clustering.

Experience in Software Development Life Cycle (SDLC), Analysing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth knowledge of T- SQL.

Experience in migrating & working with Cloud database Azure/Hyperscale (SQL Azure and SQL MI databases) and AWS and Private Clouds.

Experience in migrating Databases, SSIS packages, cubes, reports to SQL Servers.

Create and execute a cloud migration strategy to move on-premises systems to the cloud.

Experience in Creating Complex Views, Triggers Tables, Views, Indexes, Stored Procedures and User-Defined Functions to implement Business Logic and Data Protection.

Experience in creating Maintenance plans for backups, indexing and database integrity check.

Experience in different types of backups, restoration of the database and using SQL Server agent to schedule jobs and Maintenance Plans and set Database Mail settings for notifications or alerts.

Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.

Extensive experience in implementing High availability solutions like Replication (Snapshot, Transactional and Merge), Log shipping, clustering and mirroring on physical and virtual machines.

Extensively worked on setting up Always on Availability Groups and Node Clustering.

Expert in data loading services like SSIS, DTS, BCP Bulk Insert and gpdist gpload and copy commands.

Experienced in Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.

Experience in configuring and deploying Reporting Services/Power BI.

Experience in PowerShell scripting to automate DBA tasks.

Strong experience in monitoring and tuning SQL server databases for optimum performance and assistance in capacity planning of SQL server databases.

Extensively used the native tools like Index Tuning Wizard or Database Engine Tuning advisor, SQL Profiler, Performance Monitor, Activity Monitor, DBCC Commands, Event viewer for performance analysis and fix any performance related issues, ensuring optimum performance.

Monitored index fragmentation and performed index rebuild, re-org at regular intervals depending on the fragmentation levels.

Used Dynamic Management Views (DMV's), Dynamic Management Objects (DMO's) and Database Console Commands to check and gather several server level information and to perform integrity checks.

Experience in T- SQL Development skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Queries.

Experience in Creating Databases and setting up connection strings and connecting SQL Server Azure Databases from locally Installed SSMS for Developers.

Good knowledge on Jenkins/JIRA/Docker/Rundeck/Maven/Git/GitHub/Sonarcube Nexus and other DevOps tools configuration and working on issues if any in the configuration.

Supported several applications by developing and deploying fixes to resolve errors in DDL and DML.

Worked extensively on server level and database level security in providing appropriate privileges by creating logins, users, configuring permissions to views, stored procedures and tables.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Strong ability in Scheduling and deploying reports on Report manager.

Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.

Good at features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE) and Change Data Capture.

Worked with a team of business analysts, data architects, application developers and ETL developers, Testers.

Having good experience working under AGILE project management.

Experience working with the change control process.

EDUCATION & CERTIFICATIONS

Master of Information Technology, University of Ballarat- Australia- 2010.

Microsoft Certified Professional SQL Server 2012- 70-433

Technical Skills:

Database

SQL Server 2000 to2022, SQL Azure, AWS RDS, PostgreSQL 9.8.x–10.x, Oracle 11g & 11g R2

Cloud Services

Microsoft Azure, AWS (EC2, VPCX console, RDS instances – beginner level)

Operating System

Windows Server 2003 to 2019, Centos, Red hat, AIX, Solaris

Languages

T-SQL, VB.NET, Shell Scripting, PL/PGSQL, PLSQL, JavaScript, Perl

Monitoring Tools

SentryOne, SolarWinds DPA, Datadog, SiteScope, SCOM 2007 R2, SQL Diagnostic Manager, AppDynamics, Redgate, Foglight

Ticketing Tools

ServiceDesk, Jira Service Desk

ETL & BI Tools

SSIS, SSRS, SSAS, DTS

SQL Server Tools

SSMS, SQL Profiler, SQL Query Analyzer, Index Analyzer, PerfMon, Database Tuning Advisor (DTA), TOAD, Enterprise Manager, Import/Export Tools

PROFESSIONAL EXPERIENCE

Temenos USA Inc. Austin, TX Feb ‘22 – Current

Lead SQL SERVER DBA

Responsibilities:

Production support, maintenance, and administration of SQL Server and PostgreSQL.

Expertise in configuring, installation and upgrading SQL Servers on Windows Failover Cluster Services with high availability configuration.

Designing, installing, and configuring databases on Cloud (Azure SQL and SQL MI databases).

Expert at index selection including In-memory Hash and In-Range Indexes

Created a performance/throughput baseline for all databases to be migrated/upgraded.

Managed SQL server, disaster recovery strategies, Log Shipping, Clustering, always on available groups.

Involved in ETL process under development, testing and production support environments.

Expertise in configuring and installation of PostgreSQL Postgres Plus advanced Server on OLTP to OLAP systems on from high end to low end environment.

Experience in backup/restore of PostgreSQL databases.

Involved migration of SQL Server databases to PostgreSQL, ensuring seamless data transition, schema conversion, and application compatibility.

Optimized PostgreSQL performance post-migration, fine-tuning query execution plans, indexing strategies, and configuration settings for enhanced efficiency.

Converted complex stored procedures, functions, and triggers from SQL Server's T-SQL to PostgreSQL’s PL/pgSQL, ensuring functional parity.

Designed and implemented ETL processes for data migration, leveraging tools like AWS DMS, pgloader, or custom scripts to handle large datasets efficiently.

Conducted rigorous testing and validation, ensuring data integrity, query performance, and application behavior post-migration.

Collaborated with cross-functional teams, including developers and DevOps engineers, to update application code for PostgreSQL compatibility.

Provided training and documentation on PostgreSQL best practices, equipping teams with the knowledge to manage the new database environment effectively.

Established monitoring solutions for PostgreSQL databases, leveraging tools like pgAdmin, Prometheus, and Grafana to maintain system stability.

Resolved post-migration issues, troubleshooting queries, optimizing indexes, and addressing compatibility challenges.

These points showcase your technical expertise, leadership, and problem-solving abilities. Let me know if you'd like me to refine or tailor them further!

Design & manage PostgreSQL database schemas.

Monitor, troubleshoot, Optimize, and fine-tune databases Performance issues using DBCC, DMVs, DMO’s SQL server Profiler, execution plans and third-party tools.

Worked with new concepts in SQL Server 2016 such as Temporal Table, Stretch Database, Always Encrypted, Poly Base, Native JSON Support, Enhanced In-memory OLTP etc.

Worked on ETL process to migrate data from multiple data sources (SQL Server, Excel, Flat files, SharePoint) to destination database server by using SSIS packages and Export/Import wizard.

Routinely performed query tuning and other performance tuning practices to resolve issues and ensure that databases were working at their maximum capacity.

Windows Administration, Database Design, Performance Analysis, transactional production databases.

Support and troubleshoot very large databases (VLDB).

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Responsible for reviewing, optimizing, deploying database scripts requested by Application Development Team.

Automated daily tasks with PowerShell.

Auditing for changes to users, groups and computers, Directory Service Access events.

Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.

Create and modify Stored Procedures and Functions to generate reports for data migration using T- SQL.

Work with tools SQL Server Agent, SSCM, SMO, Database Tuning Advisor, SQL Server Dashboard, SQL Profiler, Activity Monitor for event monitoring, performance monitoring and make recommendations based on results.

Expert in using DMV's, DMO's, DMF's, data partitioning, DDL triggers, Mirroring and Online indexing.

Implement data availability solutions, online Restore, Online index Operation, Database Snapshot, Fast Recovery.

Conducted DR tests periodically for group of Business Units and Normalize the environment after DR.

Experience in configuring and deploying Reporting Services/Power BI.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Optimize the performance of queries with modifications in T- SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.

Responsible for day-to-day activities, such as backup and recovery of databases and transaction log on production/development servers as per business / IT needs using SQL Safe.

Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Provide 24x7 Production Database on-call support.

Environment: T-SQL, SQL Servers 2016 to 2022 Windows Server 2012 to 2019, PostgreSQL 9.8.xto 10.x, Azure SQL/MI, SSIS, SSRS, PowerShell, Redgate, TFS, VMware, SCOM, Jira, Agile, OLTP/OLAP

State of NJ (Dept of NJ Kids), Trenton, NJ Aug 2017 – Feb 2022

Senior SQL Database Administrator

Responsibilities

Participated in gathering Business Requirement, focused on providing a user-friendly System usage or ambience.

Production support, maintenance, and administration of SQL Servers.

Installed, upgraded SQL Servers and Migrating on-premises SQL Server Database to Azure.

Managed SQL server high availability and disaster recovery strategies including Log shipping, Clustering.

Monitor, troubleshoot, Optimize, and fine-tune databases' Performance issues using DBCC, DMV’s, DMO’s, SQL server Profiler and third-party tools.

Experienced in creating backup strategy for production servers.

Implemented SQL Server Auditing to collect data for Quarterly audits.

Performed Security Administration by creating Logins, Users, granting permissions, managing Schemas.

Hands on experience on VMWare serves setup and installations.

Supported Development Team in deploying and testing the application, which uses SQL Server as a database.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Export or Import data from other data sources like at les using Import/Export through DTS, SSIS.

Experienced in implementing operational automation using scripts.

Scheduled ETL jobs daily/Weekly/monthly based on business requirement in Autosys, through SQL Agent jobs.

Experienced migrating Oracle database to SQL Server, was a part of SOX audit team which would analyse user logons and access rites.

Created reports utilizing SSRS, Excel services, deployed them on SharePoint Server as per business requirements.

Migrated database structures, tables, indexes, stored procedures from development to production environment.

Configuring Alerts to be fired in the event of failed backups or performance issues.

Coordinating with multiple business and application teams in gathering the requirements, coming up with the upgrade plan and managing the SLA's and upgrading issues.

Managing all the database activities required to support the releases of new applications to production.

Coordinate administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long-range requirements, operational guidelines.

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Configure log analyzing tools pgfouine and pgbadger

Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.

Worked with the Change Manager to develop, document IT Service Management policies, processes, procedures based on ITIL best practices.

Provide 24x7 Production Database on-call support.

Environment: T-SQL, SQL Servers 2012, 2014, 2016 and 2017, Windows Server 2012/2012R2 and 2016 Datacentre, PostgreSQL 9.8.xto SQL Azure, VMWare, Visual Studio, PowerShell, AZURE, OLTP and OLAP., SSIS, SSAS, SQL Profiler, SQLCMD.

ADP, NJ Apr ‘14 – Jul ‘17

Senior SQL Database Administrator

Responsibilities

Production support, maintenance, administration and installation (Failover cluster/migration of SQL Servers

This involved index creation, index removal, index modification, and adding scheduled jobs to re-index and update statistics in databases.

Export or Import data from other data sources like at les using Import/Export through DTS, SSIS.

Analyze long running slow queries and tune the same to optimize application and system performance.

Worked with various teams to upgrades (.Net, IIS, PowerBuilder, Power Logic, SDE GIS, Windows Server).

Worked with Security/Firewall teams to open specific ports for SQL Server monitoring.

Implemented Replication, Mirroring, and Log Shipping; performed troubleshooting issues.

Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.

Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins statements for various applications.

Maintained referential integrity and implemented complex business logic.

Involved in Addressing Performance Tuning of DB’s/Instances Depending upon their Configuration and their Performance, fine tuning of Queries to help execute them in less time

Worked on real time Disaster Recovery and participated schedule DR excises.

Attending change deployment Bridge calls and ensure to complete the change requests successfully.

Updating Clients on daily/monthly/weekly status of the servers through meetings and reports,

Provided day-to-day administration tasks like space and log management.

Setup and maintain Linked Servers.

Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.

Designed and facilitated the implementation of data warehouses required by application systems

Supported OLAP team to provide data from SQL Servers. Experience in capacity planning.

Created custom SSRS reports to track the Database growth and volume changes on a periodic basis.

Provided back-end support for functional testing and performance testing.

Developed jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshed database environments periodically or on demand. SETUP notifications for failure of jobs.

Experience with RAID levels and SAN storage infrastructure.

Environment: SQL Server 2005–2016, PostgreSQL 9.8.xto, SSIS, SSAS, SQL Profiler, SQLCMD, Visual Studio

Softpal Technologies, India April 2012 - April 2014

Role: SQL Database Administrator

Responsibilities:

Installed, upgraded, configured, deployed, and managed MS SQL Server on both production and test environments both on-site and remotely.

Developed high performing Backup & Recovery strategy.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups both at database and server level.

Monitoring and configuring jobs to backup and for collecting growth rate of the databases, event logs, error logs and performance of the database.

Recovered the databases from backup in disasters and implemented Point-In-Time Recovery solutions.

Experience with Indexes, index management, integrity checks, configuration, and SQL Server patching.

Experience in configuring backups, history cleanup tasks and rebuild indexes.

Performed Production support and on Call duties

Environment: SQL Server 2000–2008R2, DTS, SSIS, SSRS, T-SQL, Windows Server 2003/2008, Query Analyzer

Contact this candidate