Ajay Sp

Solutions-oriented, consummate SQL DBA and Support professional with over 14 years of experience in accomplishing various projects end to end right from requirement mapping to implementation and support. Acquired rich and diversified experience in software management & consulting in diverse technology areas, including framing architectural decisions, technology, and product development to facilitate and enable growth and business agility. Extensive expertise in Database administration, management, maintenance administration, installation, fine-tuning, backups, and day-to-day support activities of SQL ebusiness suite, and fusion middleware applications.

Sound expertise in the assessment of operational performance & implementation of innovative ideas to enhance efficiency & effectiveness in operations of service delivery. Highly dedicated professional with demonstrated success in designing and implementing database solutions that improves business functionality. A seasoned professional with a unique blend of Managerial, Technical, Functional, and Qualitative skills backed by strong record of people management and resource optimization.

Expertise in Database Administration, Support and Performance Tuning - Installations & Troubleshooting, Backup, Restore, Recovery Issues, Database Maintenance, Database Creation & Re-Organization, Migration, and Cloning of the databases. Well-versed in building & configuring monitoring and maintaining Oracle Databases in large complex environments. Proven ability in disaster recovery (remote standby database) and security management & documentation.

Skilled in developing, analyzing, coding, and implementing Oracle-based applications using SQL,. Demonstrated capabilities in mapping client's needs and conducting gap analysis to devise cost-effective end-to-end IT solutions to maximize value perception for the customer. An ambassador of change, a keen strategist with acumen in providing effective business solutions and technical architecture to leverage technology in creating revenue opportunities.

Exceptional dedication to growing with cutting-edge technologies and seeking to achieve beyond expectation in every endeavor. Suave and pragmatic with excellent interpersonal and communication skills; popular team worker with leadership traits

SQL Database Administrator - HCL Technologies Ltd. - Bangalore

(2021-04)

• Achieved seamless migration and upgrade of obsolete and End of Life support SQL server versions 2008/2012/2014 and SQL Servers on Windows OS 2012 R2, ensuring heightened system integrity and performance.
• Streamlined daily operations and bolstered operational efficiency by developing and implementing Standard Change templates through the ITSSP tool.
• Ensured seamless integration and functionality by closely collaborating with application teams to align project requirements.
• Spearheaded planning, scheduling, and implementation of new projects while prioritizing security measures and mitigating vulnerabilities, resulting in strengthened system resilience.
• Maintained exemplary adherence to SLA benchmarks, guaranteeing timely delivery and resolution of ad hoc requests through effective team collaboration and proactive project management.
• Provided clients with comprehensive metrics and weekly project updates, showcasing tangible progress on server migrations and decommissions.
• Conducted rigorous post-quality checks, swiftly resolving migration issues related to application connectivity, thereby ensuring uninterrupted service delivery.
• Validated data integrity and facilitated informed decision-making by ensuring accuracy in SQL server inventory and alignment with Power BI reports.
• Implemented proactive communication strategies with application teams, ensuring timely migration/decommissioning of obsolete SQL servers within project timelines.
• Ensured transparency and accountability by meticulously documenting risk acceptance by application teams for unsupported higher versions.
• Demonstrated flexibility and adeptness in handling BAU operations as per demand, maintaining service continuity and efficiency.
• Expertly managed multiple critical issues, ensuring strict adherence to SLAs and minimizing downtime and impact.
• Effectively managed end-to-end change processes, assuming various pivotal roles such as Change Manager, Coordinator, Implementer, and Requestor, resulting in smooth execution and compliance.
• Led change management activities within a structured framework, effectively assessing change impact and organizational readiness to mitigate risks.
• Enhanced overall change management efficiency by evaluating change implementation processes and providing actionable guidelines to reduce potential impact.
• Ensured compliance and alignment with audit requirements by authorizing change requests and coordinating with the Change Advisory Board and application teams for changes presenting higher risk.
• Fostered continuous improvement by facilitating post-implementation reviews to evaluate decision-making and performance related to change requests.
• Provided guidance and support to application teams in raising change requests, evaluating Requests for Change (RFCs), available resources, and organizational readiness.
• Fostered understanding and adoption across the organization by supporting, training, and communicating process changes to stakeholders.

SQL Database Administrator - Shriram Group Ltd. - Bangalore

(2019-01 - 2020-10)

• Improved operational efficiency by developing and implementing Standard Change templates using the ITSSP tool, streamlining daily activities.
• Ensured seamless integration and functionality by closely collaborating with application teams, aligning project requirements.
• Strengthened system resilience by spearheading planning, scheduling, and implementation of new projects, prioritizing security measures and mitigating vulnerabilities.
• Identified and resolved blocking, deadlock, fragmentation, and performance issues utilizing system stored procedures, DBCC, Activity Monitor, and Profiler.
• Ensured seamless weekly database refreshes from Production to Test Environment.
• Managed user enrollment, access control, and database monitoring to uphold system security standards.
• Demonstrated proficiency in high availability solutions such as AlwaysOn, Replication, Database Mirroring, Log Shipping, and Cluster activities.
• Implemented cluster installations, and node additions, and conducted failover/failback operations within cluster environments.
• Configured and managed AlwaysOn setups, enhancing system reliability and continuity.
• Developed and updated SOPs for new processes, ensuring documentation accurately reflects the latest changes and improvements.
• Exceeded SLA benchmarks through effective team collaboration and proactive management of critical projects, resulting in timely delivery and resolution of ad hoc requests.
• Provided clients with comprehensive metrics and weekly project updates, showcasing tangible progress on server migrations and decommissions.
• Ensured uninterrupted service delivery by conducting rigorous post-quality checks and swiftly resolving migration issues related to application connectivity.
• Facilitated informed decision-making by validating data integrity and ensuring accuracy in SQL server inventory and alignment with Power BI reports.
• Ensured timely migration/decommissioning of obsolete SQL servers within project timelines by implementing proactive communication strategies with application teams.
• Enhanced transparency and accountability by documenting risk acceptance by application teams for unsupported higher versions.
• Demonstrated flexibility and adeptness in maintaining service continuity and efficiency through proficient management of multiple critical issues.
• Ensured smooth execution and compliance by effectively managing end-to-end change processes and assuming various pivotal roles.
• Mitigated risks effectively by leading change management activities within a structured framework, assessing change impact and organizational readiness.
• Enhanced overall change management efficiency by evaluating change implementation processes and providing actionable guidelines to reduce potential impact.
• Ensured compliance and alignment with audit requirements by authorizing change requests and coordinating with relevant stakeholders.
• Fostered continuous improvement by facilitating post-implementation reviews and providing guidance and support to application teams in raising change requests.

SQL Database Administrator - Prestige Group Ltd. - Bangalore

(2016-09 - 2019-01)

• Achieved successful installation and configuration of MS SQL Server 2012/2014/2016, ensuring optimal performance and functionality.
• Resolved tickets efficiently by creating and maintaining databases, monitoring disk space, ensuring database integrity, and identifying missing indexes, resulting in enhanced system reliability.
• Implemented and maintained database security in alignment with business rules and requirements, safeguarding sensitive data and ensuring compliance.
• Configured and troubleshot high availability scenarios such as Log Shipping, replication, mirroring, and clustering, ensuring uninterrupted access to critical data.
• Facilitated seamless database refresh from Production to Test Environment every week, promoting accurate testing and development activities.
• Maintained sound backup and recovery policies and procedures, safeguarding data integrity and facilitating swift recovery in case of incidents.
• Identified and resolved fragmentation and performance issues, optimizing database performance and enhancing overall system efficiency.
• Troubleshot blocking and space issues promptly, minimizing downtime and ensuring uninterrupted access to data.
• Executed scripts in the Production environment efficiently, facilitating smooth operations and deployments.
• Ensured data consistency in the database through meticulous execution of DBCC commands, maintaining data integrity and reliability.

SQL Database Administrator - Capgemini India Pvt. Ltd. - Bangalore

(2015-08 - 2016-08)

SQL Database Administrator - Monsanto Holdings India Pvt. Ltd. - Bangalore

(2013-10 - 2015-07)

SQL Database Administrator - IBM Global Process Services - Bangalore

(2011-07 - 2013-10)

MBA - CNK Reddy College (2009 - 2009)

Bachelor of Commerce - Computer Applications - IRM Degree College, Kuppam (2007 - 2007)