JANAKI DEVI POLISHETTY

Client : Lam Research

• Handled SQL server installations and configurations of SQL server 2008, 2012, 2014, 2016, 2017, 2019 and SQL 2022
• Led SQL server migration project, collaborate with application teams , planning migrations/upgrades and providing monthly status updates within agreed timeframes
• Delivered comprehensive technical documentation of NetApp Snap Center including design specifications and user guides for easy reference by colleagues
• Provided mentorship to junior team members, fostering professional growth and strong work ethics in the work place.
• Troubleshoot complex issues impacting production systems performance, applying root cause analysis techniques to prevent future occurrences.
• Enhanced application performance for increased user satisfaction by identifying the problematic SQL queries and provided recommendations to improve the queries.
• Collaborated with different application teams to discuss on technical database requirements and help them to setup appropriate databases
• Participated in verifying compliance with service level agreements by maintaining technical uptime levels.
• Setup high availability solutions like Always On and replication Setup database maintenance plans to re-organize indexes, re-indexing and update the index statistics on the production databases
• Reduced system downtime by implementing proactive monitoring and maintenance procedures
• Fixing issues in transaction replication Directly assisted business teams in migrating the PostgreSQL database hosted on Linux to Azure PostgreSQL database
• Automate the SQL 2022 installation using SCCM
• Provided the costing details of Azure databases to application teams and encourage them to setup the databases in Azure (Dbaas)
• Successfully migrated several critical tier 1 databases to highest version of SQL with ZERO downtime by using cluster rollover upgrade concept
• Maintained full compliance with best practices through rigorous security audits and vulnerability assessments
• From database end handled the DR exercise and made sure all SQL servers are up healthy
• Effectively used incident, change and problem management using ServiceNow following ITIL frame work

Environment: MSSQL server 2008/2012/2014/2016/2017/2019, Windows Server 2008 R2; Oracle 11g, IBM-AX, Linux

Tools: NetApp Snap Center for SQL, SolarWinds, SCOM, Fog Light, Azure Log Analytics, SMSQL

Client : Lam Research

• Monitored the backup status reports, failed job reports
• Increased database uptime through proactive monitoring of alerts and swift resolution of potential issues.
• Managed SQL server upgrades, ensuring minimal impact on daily operations while enhancing overall system capabilities.
• Established effective communication between cross functional teams promoting collaboration across teams to achieve shared goals more efficiently
• Provided technical recommendations to optimize SQL queries
• Promptly resolved technical issues to minimize server downtime
• Analyzed the existing databases and recommended enhancements to maintain compliance

Client : PriceWaterHouseCoopers

• Provided DBA Support to all environments involved in PwC
• Managed Dev, Test and Production servers
• Fixed performance related issues and identified the blocks, slow running queries using DMV’s and DBCC commands
• Identified the Indexes with high fragmentation and de-fragmented the indexes to avoid long running of SAP jobs
• Managed security of SQL Server 2008, 2008R2, 2012 and 2014 by creating database users, roles and assigning proper permissions according to business requirement
• Proficient with SQL Server tools including Management Studio, SQL server agent
• Involved in SQL server technologies Replication, Clustering
• Creating weekly and monthly reports for database growth and performance statistics
• Troubleshooting the performance issues
• Worked on Net backup SQL client to perform backup and restore of databases
• Ensuring that all databases are backed up on regular basis by monitoring full, differential and transaction log backups
• Fixing backup failures, address and implement resolutions
• Worked with Microsoft in critical situations to resolve the issues
• Key point of contact for Weekly/Monthly reports (SLA, IMS etc.) Good Knowledge on incident, Problem & change management
• Resolving Space management issues like database and log space issues
• Monitoring SQL server performance using profiler to find performance and deadlocks
• Verifying all instances are up and running as per the checklist
• Creating Indexes on tables to improve the performance as per Dev/App team request
• Recovering the databases from backup in disaster situations
• Performing SQL server daily health check and preparing a report based on it
• Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e
• Older Backups, Unused Files etc
• Handling Outage Notifications accordingly and following the process during production maintenance/production down issues

Tools: SM9, Net backup SQL Client

Client : Baker Hughes

• Setting up and troubleshooting replication
• Worked with SQL server 2008 in place and side by side upgrade from SQL server 2005
• Worked on project for setting up DB mirroring and troubleshooting
• Successfully implemented capacity planning for different servers
• Experience working with data-tier application DAC for migration Experience
• working with SQL Database Migration Wizard SQL Azure MW and Azure SQL Database Preview v12
• Worked on setting up of active-active clusters
• Implementation of SQL principle, securable, permission, roles and authentication modes as a part of security policies for various categories of users
• Database, Logins, Job and other DB object Backups and Restoration of the same
• Applying service packs and security patches for the servers to the latest release available in the market