Krishna Deepak Chamana Email & Phone Number

Bengaluru, Karnataka, India

• Possess in-depth knowledge of DBA & Infrastructure technologies, including multiple database technologies like SQL Server, Oracle, No-SQL databases, Cloud Computing, Windows/Unix, Active-Directory, Networking and Server Administration.• Provided technical guidance and support to team members, fostering continuous learning and skill development.• Developed and executed comprehensive plans for infrastructure projects.• Implemented scalable infrastructure solutions to support business growth.• Proactively identified and addressed potential risks, ensuring project-success• Cost-effective infrastructure solutions with performance or security.• Conducted thorough cost-benefit analyses to optimize resource allocation and reduce operational expenses.• Effectively communicated technical information to non-technical stakeholders, facilitating understanding and collaboration.• Established clear lines of communication within the team and with other departments to streamline project workflows.• Successfully managed and led teams through technology transitions and infrastructure upgrades.• Implemented change management processes with minimal disruptions to ongoing operations.• Maintained partnerships with vendors to ensure procurement of Infra staff and resources for handling services.• Negotiated contracts and managed vendors to optimize value & delivery.• Implemented continuous improvement initiatives to enhance the efficiency and effectiveness of infrastructure processes.• Encouraged a culture of innovation and adaptation to emerging technologies.• Led and mentored cross-functional DBA teams (Ops & Engineering), fostering a collaborative and high-performance culture.

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

Bangalore

•Handling vulnerability remediation and hardening of SQL Server instances using IBM Guardium tools and non-tool implementations.•Handling escalations as Level 3 and being available as point of escalation for entire project scope.•Fine tuning queries and providing recommendations. •Setting up alerts and email management for newly built servers. •Index optimization and implementing index maintenance routines.•Experience in SSIS and SSRS.•Improving query performance using different methodologies (Index Fragmentation, Table Statistics Analysis, Recommendations on filegroups, TempDB optimization, VLF count increase)•Node failure troubleshooting, Patch installations, Rolling upgrades, Failover and RCA’s for all P1 and Outage driven issues.•Performed SYSPREP Image preparation and completion of images.•Worked on Unattended slipstream installations of SQL Server 2012 and earlier.•Worked on Replication issues and troubleshooting any failures of agents and ensuring Publisher data is submitted to subscriber.

SQL Server Database Consultant for IT Operations. I support the database services for Autonomy applications.•Performing code reviews and making sure the code changes are reflected in Production environment are well tested.•Performed Automated installations integrated with Powershell scripts.•Using Best Practice Analyzer to make environment with stable settings.•Fine tuning queries and providing recommendations on best utilization. •Hardening SQL Server instance configurations and database settings•Setting up alerts and email management for newly built servers. •Fixing any escalated issues and trying to meet up with SLA’s.•Index optimization and implementing index maintenance routines.•Performed migrations (also in-place) from SQL Server 2005 to 2008 R2.•Performed migrations from SQL Server 2005/2008R2 to 2012.•Improving query performance using different methodologies (Index Fragmentation, Table Statistics Analysis, Recommendations on filegroups, TempDB optimization, VLF count increase)•Node failure troubleshooting, Patch installations, Rolling upgrades, Failover and RCA’s for all P1 and Outage driven issues.•Implemented AlwaysOn on SQL Server 2012 for read-only and offloading backups to Standby site.

Bangalore

•SQL Server 2008 R2 deployments using Building Blocks•Optimized installation times through Slipstream installations•Hardening SQL Server instance configurations and database settings•Creating alert notifications through email and for critical system errors •Fixing MSI and MSP corruptions for any failed installations of SP’s•Performed migrations (also in-place) from SQL Server 2005 to 2008 R2•Mirror failures through Mirror Monitor and resolving sync/corruption •Worked on replication models and verifying replication agents status•Working on deadlocks and blockings and identifying the key session •Improving query performance by finding missing and unwanted indexes •Fixing 14420 and 14421 errors of log shipping and also job failures•Handling escalations in team related to Clustering and Tuning•Performing database refresh across different versions•Creating Jobs/MPs for most frequent tasks like checking the integrity of database, rebuild index•Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach•Configuring / maintaining high availability SQL Server solutions that include Log shipping, Mirroring, Replication•Implement database administration/ maintenance plans and monitor •Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure•Contacting Microsoft support for high end critical issues •Handling the database suspect situations and resolving with no data loss•Regular checking of the database consistency using DBCC commands •Creating CR’s for every client-raised request and from application team•Preparing RCA required for critical issues and also for problem tickets•Preparing MOM for all the meetings held for other team members•Keep track of all databases & server information in Portal for newbie’s•Documenting all new resolved tasks/environment details in sharepoint

•SQL Server 2000 deployments and patching•Hardening SQL Server instance configurations and database settings•Creating alert notifications through email and for critical system errors •Worked on replication models and verifying replication agents status•Working on deadlocks and blockings and identifying the key session •Creating Jobs/MPs for most frequent tasks like checking the integrity of database, rebuild index

Master Of Science (M.S.), Information Systems

Batchelor Of Computer Applications, Computer Applications