SRIKANTH JASTI

Email: adijbc@r.postjobfree.com phone: 203-***-****

SUMMARY

•Expert in the database modeling, design, development, maintenance and administration.

•Experience includes System analysis and design, development, support on systems built on MS SQL Servers 2000/2005/2008R2/2012/2014/2016/2017/2019.

•Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

•Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.

•Experience migrating data from one server to another server by side-by-side upgrade process.

•Extensively Worked on Transactional Replication, Snapshot Replication, Merge Replication, and Log shipping for SQL Server High Availability.

•Good developing skills in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.

•Implemented the SQL Server concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-catch blocks, Online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.

•Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).

•Created Linked Servers between SQL Server 2000 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

•Proficient in high level design of ETL, DTS and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, etc.).

•Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.

•Used third party tools for monitoring, backups and restores like Idera, Red Gate, TSM and NetBackup.

•Proven ability to work in teams as well as independently.

•TECHNICAL SKILLS

Databases

MS SQL Server 2000/2005/2008/2008 R2/2012/2014/2016/2017/2019, Access.

Database tools

Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication.

Programming languages

SQL, TSQL, C.

Tools

SQL DB Access, Performance Monitor, Backup Utility, Net Backup, Data Stage 5.0.

Operating Systems

Windows XP/NT/2000, Windows Server 2000/ 2003 /2008/2012.

EDUCATION BACKGROUND

•Bachelors in Electronics and Communications Engineering, Anna University, Chennai, India.

PROFESSIONAL EXPERIENCE

08/20 – 12/20: Sr. SQL Server Developer/DBA

Abacus Insights, Boston, MA

Responsibilities:

Gathering business requirements and creating stories for development.

Worked on implementing Change Data Capture for moving data between servers.

Created tables, synonyms, primary keys, Unique Keys and Indexes.

Created stored procedures to transfer data between servers using CDC system functions.

Used CDC system functions to map time to lsn values and through understanding of CDC internals.

Created DEMOs to explain the internals of CDC to the team members.

Used nodes and value functions in XML and used OPEN XML to extract XML data of a column into multiple columns and joined with master table.

Performance tuning of XML extraction for a table with 100’s millions of rows.

Used Gitlab for check-in code, code reviews and version control.

Created databases for QA team and deployed the code from the master.

Created reusable components (stored procedures) to use same code for all the modules with little to no changes.

Created meta data for each module to facilitate the re-usage of stored procedures.

Worked in an Agile development environment.

Worked on AWS EC2 and RDS servers.

Used TRY CATCH statements inside and outside cursor for error handling.

Used throw statement to throw an exception if parameters of stored proc received NULL values or invalid values.

02/18 – 06/2020: Sr. SQL Server DBA/Developer

Department of Mental Health, Boston, MA

Responsibilities:

•Designed Database for DMH expedited referrals and CYF Services projects using Normalization and DE normalization rules of Database Design.

•Created SSIS packages to export data from flat files to SQL Server.

•Designed and created reports for Client Data Summary and all other reports for the internal and external users using SSRS.

•Identified CPU, Memory Bottlenecks using perfmon and wait statistics.

•Configured MAX Degree of Parallelism and Cost threshold for parallelism to minimize CXPACKET and SOS_Scheduler_yield wait types.

•Suggested to add CPUs for eliminating SOS_Scheduler_Yield wait types.

•Identified Database maintenance not happening, created jobs to run Database Consistency checks, defragmentation of Indexes and updating statistics.

•Identified blockings in OLTP environment of a Pharmacy application and asked the internal users to direct their entire read only and reporting queries to secondary replica of Always on using application Intent read only in the connection string.

•Worked with users to understand the worked load and tuned queries as per the Indexes and did Index consolidation to make queries run faster.

•Involved in migration of on-prem databases to AWS cloud.

•Experience working with amazon RDS server.

10/17 – 12/17: SQL Server Architect

Mass Eye and Ear Infirmary, Charlestown, MA

Responsibilities:

•Captured perfmon metrics to baseline and benchmarking system performance.

•Analyzed perfmon metrics to find Memory, I/O and CPU Bottlenecks.

•Worked with environment with heavy loads (50 Million records per DB) and reads.

•Gathered long running queries and wait stats information to tune queries.

•Dropped unnecessary Indexes and created new and covering Indexes and consolidated Indexes.

•Expert in choosing partition column, Clustered Index and Non-clustered Index based on the workload.

•Implemented table partitioning and file groups to distribute the 2.5 TB space from single file to Multiple Files and File groups.

•Created Indexed views to improve performance of the reporting queries.

•Worked closely with all the teams to gather bad performing queries and rewrite the queries.

•Recommended change of schema design and data type changes to improve performance and to save disk space.

02/13 – 08/17: Sr. Database Administrator

Center for Health Information & Analysis, Boston, MA

Responsibilities:

•Managed and Administered the SQL Server 2008/2005/2000/2012 production and Non-production servers.

•Involved in Capacity management and Analysis at hardware of the SQL Server including CPU, Memory and Storage.

•Evaluated data storage considerations to store databases and transaction logs.

•Managed trouble shooting of Client connections, viewing error log and applications.

•Implemented high availability strategies Always ON, Database Mirroring, Replication and Log shipping.

•Designed SQL Jobs to capture index usage, duplicate indexes, overlapping indexes, fragmentation etc. to periodically monitor the performance of the application databases.

•Troubleshooting Blockings & Deadlock issues in SQL Server.

•Maintaining the database consistency with DBCC utility at regular intervals.

•Maintained always on cluster environment. Role switch and troubleshooting Always on Environment on Windows and SQL Server 2012.

•Transferred data to Data warehouse Environment using SSIS and Datastage 11.0.

•Suggested better way to recover databases from disaster i.e. disaster recovery.

•Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.

•Good experience in running jobs and fixing errors in Data Stage 5.0 and 11.0.

•Data stage jobs scheduling and troubleshooting.

•Configured lock pages in memory for resolving Memory bottlenecks.

•Created jobs to monitor errors of last 24 hours and send emails to the DBA team.

•Created maintenance plans for backups, Index rebuild or reorganize and Update Stats.

•Experience in troubleshooting queries running on 10TB databases.

•Identifying CPU, Memory and I/O bottlenecks and the queries causing it.

•Very good understanding of data and log files configuration.

•Creating Linked servers for distributed queries.

•Data stage jobs scheduling and troubleshooting.

03/12 – 12/12: Database Administrator

DCP Midstream, Denver, CO

Responsibilities:

•Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.

•Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to SQL Server 2005

•Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.

•Migrated DTS packages to SSIS packages and maintained the archival data.

•Recovered User database from suspect mode.

•Extensively worked on troubleshooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually.

•Hands on experience in troubleshooting database issues. Update statistics, database integrity check and Backup operations

•Worked on call 24/7 Support on weekly basis

05/09 – 08/10: SQL DBA

Universal Group of Institutions, India

Responsibilities:

•Applied Normalization rules in designing the database.

•Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced referential integrity.

•Deployed scripts in production.

•Managing User permissions i.e. logins and users.

Professional references will be provided upon request.

Contact this candidate