Kiran Kulkarni

MSSQL/MYSQL DATABASE ADMINISTRATION

IT professional with 4+ Years hands-on experience in managing large-scale databases in production support environment on windows platform and Linux. A database administrator with a proven track record of technical skills, who could work on multiple highly visible projects, is a creative problem solver, and has
an aptitude for learning.

• Experience on Installing, configuring, monitoring and troubleshooting SQL Server
• Experience in upgrading SQL Server to new versions and applying service packs and hot fixes
• Management of Database Space, Growth Monitoring of Data & Transaction log files
• Expertise in Database Administration on Production Servers with server configuration performance monitoring and maintenance with outstanding troubleshooting capabilities
• Administering SQL Server High Availability and Disaster Recovery strategies
• Set-up DB Mail and SQL Server Alerts (Disk Space, T-Log Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc..)
• Worked extensively on Clustering
• Creating Indexes on tables to improve the performance as per Dev/App team request
• Proficiency and expertise in SQL Server Replication, Backup/Recovery
• Having hands on experience in DR processes including Log shipping and Database Mirroring
• 24 X 5 Production Database on Call Support.
• Worked as MYSQL l 8.016 database administrator and as Oracle 19c As DBA (part time)
• Worked Knowledge on AWS Dynamo And Red shift With Microsoft Azure SQL.

• Learn relevant Business processes and understand the Data flow, Criticality and Dependencies
• Customer ticket analysis giving resolution with defined SLA
• MSDB maintenance and Data clean-up activity, creating user defined Jobs using Stored Procedures
• Mapping Orphan users to databases
• Provide (24/7) support for Critical Production environments
• Experience in SQL scripting for various ADHOC reports requesting by end users
• Performing Server Health check-up (Space issues, CPU utilization, Memory Utilization) Daily basis
• Analyse, Solve and Correct issues in Real-time
• Documenting RCA and providing RCA report
• Performed SQL server Migration, Patch Up gradation
• DR Drill activity, Roll-over and Roll-back Primary servers to Secondary DR servers and Vice Versa
• Configured Always on High Availability for Production servers
• Configured log shipping and Database mirroring
• SQL server installation in Stand Alone mode and Fail over Cluster mode
• Performed Try catch, Exception handling on queries
• Refine and automate regular processes, track issues, and document changes
• Perform Scheduled maintenance and support Release deployment activities aftermarket hours
• TSQL scripting and implementing for betterment of Stored ProceduresMSSQL DBA
• Assist developers with query tuning and schema refinement.
• Ensure High level performance, availability, sustainability and security
• Worked on Linked Servers and its related issues.
• Effectively coordinate and communicate with all the STAKEHOLDERS (Internal teams and Clients)
• Set up and Maintain database infrastructure for the company's BI needs.
• Develop strategies and implement solutions for managing Back-ups, Restoration and Replication
• Create and Manage Maintenance plans, User defined Jobs, Constraints and Indexes
• Maintain data Integrity and Security (Manage roles and permissions of database users).

• Date of Birth: 04/24/97
• Nationality: Indian
• Marital Status: Unmarried