Jayapal Ippa

Contact Info: +1-732-***-**** adyigy@r.postjobfree.com

https://www.linkedin.com/in/jayapal-ippa/

PROFILE

Certified MSSQL Administration and Azure with over 14+ years of experience in MSSQL Database Administration and Azure SQL and that is continuous integration and continuous delivery to orchestrate workflows for system development circle and maintenance which ensure smooth business operations, reliant architecture, and highly scalable elastic applications. highly skilled at database maintenance, performance tuning and optimizations; on-prem to cloud migration, high Availability and DR solutions. I am a passionate contributor to team success with records of empowering teams. A self-starter who is always motivated to learn, grow, and stay current.

Extensively worked on Installing, Configuring, Optimizing and 24X7 Production Support of MS SQL Server 2019/2017/2016/2012/2008R2/2008/2005 in Production, Stage and Dev Environments.

Engaged in various DR and HA efforts with Always On, Log shipping and Mirroring and Replication in SQL Server.

Upgradation of the environment from 2008 to 2012 and 208R2 to 2014 and 2012 to SQL2016/SQL2019.

Performed SQL Databases Migrations from Prod to non-prod and from on-premises to Azure IAAS or PAAS servers.

Expert in Monitoring, in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Check using DBCC Utilities.

Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Oracle to MS SQL Server by using DTS Import/Export utility, and SSIS package.

Performed code reviews and deployments Stored procedures, views, Tables, T-SQL scripting by using SSMS.

Participated in SSIS and SSRS Installation and Configured and deployed packages and reports in SQL Server.

Hands on experience in Migrations from on-premises to Azure IAAS and PAAS servers

Good experience in Azure Geo-Replication, Availability Group(s) and Data Sync

Obtaining good knowledge on saving the cost on Azure models, Deploy, Configure on Azure IAAS and PAAS servers.

Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.

Work management and work Items and status tracking using Azure Boards.

Experience in Handling Clustering (VERITAS and Microsoft)

Proficiency and expertise in FCI, Disaster Recovery, and Windows Failover Clustering for SQL Workloads.

Knowledge on CHEF, Jenkins and GitHub can work on these tools.

We transform the source data from multiple sources by using SSIS packages.

Good work experience with other RDBMS technologies PostGRESQL and DB2.

Expertise in Microsoft Azure Cloud Services (PaaS & IaaS), Application Insights, Document DB, Internet of Things (IoT), Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Aware of Agile methodologies, Kanban and Lean Certified.

Working knowledge in Incident, Problem and Change process which is the part of ITIL (ITIL V3 Foundation Certified).

Provided oversight, tasking, mentorship, and strategic direction for database administration team.

Flexible, enthusiastic, and project-oriented team player with solid leadership skills to develop creative solutions for challenging clients.

CERTIFICATIONS

Certified Microsoft Fundamentals (AZ-900) from Microsoft

Certified Microsoft Azure Administrator Associate (AZ-104) from Microsoft

Certified Microsoft SQL Server 2005 (70-431) from Microsoft

Certified ITIL V3 Foundation

Education:

Bachelors in computer science from Kakatiya University, India

TECHNICAL SKILLS

Software Tools/Apps

JIRA, RALLY, ServiceNow, HPSM, ITG, IDERA SQL Diagnostic Manager and RedGate, VStudio

Skills

Microsoft Azure, MSSQL Server, PowerBI, SSIS, SSRS, PostgreSQL, Mongo, RALLY, Jenkins, GITHUB, JIRA, CHEF and PowerShell, T-SQL, ADF, Azure Synopses and Snowflake

Cloud Computing Platform

Azure, AWS, and Snowflake

Operating Systems

Windows 20016, 2012, 2008 and NT & Linux (Ubuntu & RedHat)

Programming Languages

T-SQL, PowerShell, and Unix

EXPERIENCE

Wolters Kluwer, USA

Lead DBA SQL/Azure

January ‘23- Till date

Mentoring offshore Team and Installations and Configuration SQL Server 2017 and SQL Version 2019.

Configuring and maintaining DR&High Availability Solutions (AlwaysOn, Clustering) on On-Prim/Cloud.

Configuring Azure Services PAAS/IAAS and migrated databases from On-Prime to Azure

Working on Production databases Upgradation from SQL 2012 to SQL 2019 under change management.

Production support, deployments, monitoring, issues troubleshooting, optimization and tuning of SQL server.

Implementing Failover Cluster and AlwaysOn Configuration and Replication on On-Premises environments.

Experience in handling Day to Day and regular tasks in SSMS automation by using T-SQL.

DB alerts monitoring and collaborated with various teams on Database and server related issues.

Working experience on Deployments, maintenance, upgrade and support of Cloud infrastructure and Servers.

Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Working on Migration of databases from on premises to Azure Cloud environment.

Created maintenance plans for databases using Azure Elastic jobs and Azure automation methods.

Configured and maintained Elastic DB pools and Geo Replication

Experience in optimizing/tuning objects, indexing and partitioning for better performance and efficiency.

Automated and reduced workflow with the help of stored procedures and PowerShell scripts, that runs daily to recognize, rebuild, integrity and update statistics.

experience in creating tables, views, triggers, Stored procedures, User defined functions and other T-SQL (DDL, DML) statements of various applications.

Performance issues, Query tuning towards enhancing the system availability in applications expected manner.

Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses.

Installing and configuring SSRS, SSIS and deploying the packages to reporting server and jobs.

Work and collaborate with different teams like application, storage and networking and other database teams.

Worked in Database Engineering team and coordinating with Application to run the platform with 99.99% uptime and zero downtime release management.

Provided & managed support to Environment of more than 5000 MSSQL Database Servers in Production environment.

Worked on DR and HA solutions with Always On, Mirroring, Log Shipping and Replication configuration and maintenance.

Worked on DB Migration Projects from SQL 2008R2 to SQL 2012/2014 & SQL 2012/2014 to SQL 2016/ 2019.

Performed Database consistency checks using DBCC Utilities, Recompiling Stored Procedures, and Index Maintenance.

Hands on experience in optimizing/tuning objects, indexing for better performance and efficiency.

Succeeding Performance Tuning, capacity planning and trend analysis and server sizing for larger Databases.

Handled Heterogeneous and Homogeneous migrations, involved DB2 and Sybase Databases to MSSQL server migration with complexity Alwayson and Replication includes.

Worked for SSIS Packages migration from Server to another Server.

Worked on Deployment, maintenance, upgrade and support of Cloud infrastructure and Servers.

Proficiency worked with Azure PaaS environment, Migrating On-perm SQL Database to Azure PaaS SQL.

Designing and implementing Azure infrastructure to meet customers’ business needs related to storage, networking, etc.

Worked on Serverless and dedicated SQL Pools and Implemented Azure Function, Logic Apps

Handled Configuring the Azure Alerts using Log Analytics and App Insights.

Experience in managing Azure security, Identity, Storage and Network components.

Improve release process by automating manual activities, creating the branches, and managing the Configuration and maintenance of Azure services for different applications.

Monitors technical and engineering progress to ensure strategies, goals and objectives are met. Aligns operational plans with business objectives. Communicates changes to all affected personnel.

Created, administered & maintained SQL Server Databases (Development, Test, Staging and Production Env.) for other groups such as Developer, QA, and User etc. and ensured the Availability of the Database Server in a 24X7 Environment.

Setup the automated environments for patching SQL Servers using PowerShell.

Provided & managed Production Oncall support and handled P1/P2 war rooms.

Ensured tasks are assigned to team members based on priority and due dates.

Installed and configured and worked for PostgreSQL and DB2 on Linux Platforms.

Presents periodic updates to Senior Management on impairments, mitigation opportunities and progress.

Manage, mentor, and develop onshore development resources and provide project related directions to offshore team.

Managed and tracked all RALLY updates to maintain transparency in task’s progress (Burndown)

Installation, Upgradation, Configuration, Maintenance & Troubleshooting of the SQL Server 2000/2005/2008/2008R2 Database on standalone & clusters.

Upgradation/Migration of SQL servers from version 2000 to 2005 and SQL2005 to 2008 and 2008R2.

Responsible for implementation and release of database changes according to agreed timescales and cost

Documenting standard support procedures for resolving issues, communicating with the customer and other IT teams, implementing new SQL 2008 systems, and maintaining system integrity.

Troubleshooting SQL Server production issues in accordance with the Problem & Change Management processes

Implementation of DR planning and high availability solutions like Database Mirroring, Replication & Log shipping.

Worked on SSIS and SSRS configuration and uploaded packages on Integration and RDL files for Reporting Servers.

Configured and managed Veritas and MS clustering and Storage mapped /caped as per the requirements.

Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking.

Installation and configuration of SQL server 2005 in development, production, testing, environments

Migrated from SQL 2005 to SQL 2005 from Dev to UAT to Prod.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Implemented log shipping for hot stand by servers.

Provided 24 X 7 dedicated support to all Production Environments

Adding users in the Database and granting permissions and Scheduling jobs in SQL Server.

Developed standards and guidelines to maintain and develop and administer the SQL Server database.

Transferred the data to homogenous and heterogeneous platforms using DTS utility.

Fine tuning the Database Settings as well as the Server Settings.

Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed.

Created test cases, test planning, test execution and hands on experience in functional testing.

Optimized the SQL queries and stored procedures by performance tuning.

References: Available on Request

Contact this candidate