Subhash Chandra Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

Leading the Charge in Global Data Center Management (India, Singapore, KSA & Dubai - 24/7 Support):Championed all aspects of database administration (MS-SQL, MySQL, MariaDB, PostgreSQL, Redis, MogoDB, Solr, Neo4j), from strategic planning and architecture to scaling, performance tuning, automation, and risk management.Spearheaded data warehousing, encryption, security patching, and meticulous DDL & DML logs auditing, ensuring exceptional service quality.Global Vision, Agile Execution:Oversaw the successful operation of PeopleStrong's global databases and infrastructure, fostering close collaboration with IT, DevOps, and support teams.Provided strategic vision on architectural issues, driving informed decision-making for optimal performance.Unwavering Reliability - A Disaster Recovery Champion:Architected and implemented comprehensive disaster recovery strategies, achieving and maintaining exceptional uptime (24/7 availability and 99.99% uptime).Developer's Trusted Partner:Collaborated seamlessly with developers and DevOps teams to enhance database performance, reliability, and fostering a strong culture of teamwork.Performance Optimization Maestro:Optimized and configured databases for real-world usage, ensuring efficient and smooth operations across the organization.Code Craftsmanship Champion:Established robust coding procedures and code review policies, consistently exceeding expectations while meeting project deadlines.Problem-Solving Ace:Analyzed logs and metrics with meticulous precision, pinpointing problematic queries and proposing effective performance improvements.Release Rockstar:Played a pivotal role in flawless product releases, applying schema changes reliably and consistently – keeping the digital engine running smoothly.Unparalleled Expertise:Possesses a comprehensive skillset encompassing all aspects of the database lifecycle – from strategic planning and architecture to optimization, security, and disaster recovery.

Gurgaon

1. Global Data Center Operations: India, Singapore, KSA & Dubai (24/7 Support).1.1 Lead Database Administration: Lead all aspects, from strategic planning and architecture to scaling, performance tuning, automation, and risk management. Championed data warehousing, encryption, security, patching, and meticulous DDL & DML logs auditing, ensuring top-notch service quality.2. Standardized Excellence: Established and enforced robust organizational standards, guaranteeing consistently high-quality database operations.3. Global Vision, Agile Execution: Owned the operation of PeopleStrong's global databases and infrastructure, collaborating closely with IT, DevOps, and support. Provided strategic vision on architectural issues, driving informed decision-making.4. Disaster Defeated: Architected and implemented comprehensive disaster recovery strategies for 24/7 availability and 99.99% uptime, a testament to my resilience as Senior Lead Operational DBA.5. Developer's Friend: Collaborated seamlessly with development and DevOps teams to enhance database performance and reliability, fostering a strong culture of teamwork.6. Performance Precision: Optimized and configured databases for optimal real-world usage, guaranteeing efficiency and smooth operations.7. Code Guru: Established coding procedures and robust code review policies, consistently meeting project deadlines and exceeding expectations.8. Problem Solver Extraordinaire: Analyzed logs and metrics with eagle eyes, pinpointing problematic queries and proposing effective performance improvements.9. Release Rockstar: Supported product releases flawlessly, applying schema changes reliably and consistently, keeping the digital engine humming.10. Skilled in all aspects of the database lifecycle, from strategic planning and architecture to optimization, security, and disaster recovery

Gurgaon, India

1. Global Database Ownership: I drive the operation of PeopleStrong's global databases and infrastructure, partnering closely with IT, DevOps, and support. I provide strategic vision on architectural issues, guiding informed decision-making for high-performance, scalable solutions.2. 24/7 Uptime Architect: As Senior Lead Operational DBA, I design and implement robust disaster recovery strategies, ensuring 99.99% uptime and unparalleled responsiveness across the database environment.3. Performance Optimization Champion: I collaborate with development and DevOps teams to optimize database performance and reliability, fostering a collaborative culture for continuous improvement.4. Usage-Tailored Infrastructure: I ensure database infrastructure is tuned, optimized, and configured for real-world usage, maximizing efficiency and minimizing downtime.5. High Availability Champion: I spearheaded the implementation of clustered and standby server environments with Always-on (MS-SQL) and Master configurations (MariaDB, PostgreSQL, Redis) for PeopleStrong websites, guaranteeing high availability and seamless disaster recovery.6. Coding Governance: I established database coding procedures and code review policies, driving quality control and consistently exceeding project timelines.7. Performance Sleuth: I analyze logs and metrics with a keen eye, identifying problematic queries and recommending effective performance-boosting changes.8. Release Reliability Guru: I flawlessly support product releases by applying schema changes reliably and consistently, ensuring smooth deployments and uninterrupted operations.9. Comprehensive Database Support: I handle installation, configuration, monitoring, housekeeping, upgrades, patching, troubleshooting, and root cause analysis for all databases.10. Security & Compliance Expert: I manage user security and audit logs, exceeding defined company policies and ensuring robust data encryption across databases.

Gurgaon, India

Leadership:Executive IT Leader: Led cross-functional teams and projects, driving business growth through strategic IT initiatives and ensuring high-performance operations.Tech Visionary: Championed the company's technology strategy, aligning it with industry trends and emerging platforms to ensure continuous innovation.Effective Communicator: Articulated the vision and value of IT projects to stakeholders, including investors, management, and customers.Team Builder and Mentor: Managed and developed internal teams, fostering collaboration and expertise.External Collaboration: Strategically engaged with vendors and technology partners to optimize the IT landscape.Technical Expertise:IT Infrastructure Architect: Developed and implemented comprehensive IT frameworks to support all organizational needs.Enterprise Systems Integration: Led successful integrations of ERP, CRM, HRMS, and legacy systems, streamlining operations and boosting efficiency.Cybersecurity Champion: Implemented robust user security measures and audit controls to ensure data integrity and compliance.Database Management Mastermind: Migrated database instances, implemented encryption, and optimized performance across diverse platforms (SQL Server, MySQL, MariaDB, Redis, Couchbase, MongoDB, PostgreSQL).Cloud & Datacenter Expertise: Managed IT infrastructure across local, Reliance, CTRLS, Amazon, Azure, and Nextgen environments.Big Data Savvy: Leveraged Hadoop for advanced data analytics and insights.Industry Experience:Demonstrated Success Across Diverse Sectors: Life Insurance, Healthcare, Education, Telecom, Human Resources, and Information Technology.

Gurgaon, India

1. Database Guardian: Oversaw comprehensive monitoring and maintenance for a diverse ecosystem of databases, including SQL Server, Hadoop, MySQL/MariaDB, Couchbase, Cassandra, PostgreSQL, and Redis, ensuring optimal performance and reliability.2. Performance Watchdog: Proactively analyzed database performance, identifying and addressing bottlenecks like blocking, high CPU/memory usage, and problematic queries. Established robust alerting mechanisms for scheduled job failures, ensuring swift remediation.3. Data Guardian: Vigilantly managed user security, audit logs, and database encryption, rigorously adhering to company policies and safeguarding sensitive data against unauthorized access.4. Team Leader Expertise: Led a 5-member DBA team, expertly guiding daily operations, resolving escalated L3/L4 issues, and fostering a collaborative environment for knowledge sharing and continuous improvement.5. Disaster Resilience Architect: Championed disaster recovery planning with defined RTO and RPO, ensuring business continuity in the face of unforeseen events. Proactively managed database growth and capacity planning to anticipate future needs and prevent performance degradation.6. High Availability Strategist: Implemented high-availability solutions like SQL Server clustering, log shipping, replication, Always On, and group failover, minimizing downtime and maximizing database uptime.7. Datacenter Migration Navigator: Seamless guidance in migrating entire datacenter setups across locations and service providers (CTRLS, AWS, NxtGen, Azure), ensuring smooth transitions and uninterrupted operations.

Gurgaon, India

1. SQL Guardian:Assumed primary responsibility for managing all SQL database servers.Proactively monitored performance metrics (CPU, memory, blocking, query execution) to promptly address bottlenecks.Implemented robust alerting and remediation systems for failures, ensuring continuous uptime.2. Azure Adept:Demonstrated expertise in Azure SQL Database and Azure RSS server configuration and management.3. Security Sentinel:Rigorously managed user security and executed maintenance plans, safeguarding database integrity and confidentiality.4. Process Champion:Adhered to ITIL best practices by meticulously documenting and tracking all tasks through INIITIAN ticketing portal.5. Modernization Maven:Executed database upgrades to newer SQL versions and hardware, leveraging cutting-edge technologies and optimizing performance.6. High Availability Hero:Implemented high-availability solutions including clustering, log shipping, replication, Always On, and group failover, minimizing downtime and ensuring business continuity.Key Improvements:Stronger Action Verbs: Emphasized verbs that showcase your proactive actions and impact.Clearer Language: Used concise, easy-to-understand language, avoiding unnecessary jargon.Quantifiable Impact: Where possible, highlighted quantifiable improvements (e.g., reduced downtime, performance gains).Tailored Focus: Reordered bullet points to prioritize key strengths and align with potential job requirements.

Gurgaon, India

• SQL Server Steward:Ensured optimal performance and availability of all SQL database servers through proactive monitoring and timely remediation of SCOM alerts.Effectively managed user security and consistently executed maintenance plans to safeguard data integrity and compliance.• Azure Acumen:Demonstrated proficiency in configuring and managing SQL Azure databases and Azure RSS servers, showcasing adaptability to cloud environments.• ITIL Advocate:Reliably tracked and resolved issues using the INIITIAN ticketing portal, adhering to ITIL best practices for transparency and process efficiency.• Modernization Expert:Successfully upgraded databases to newer SQL versions and hardware, leveraging the latest technologies to enhance performance and capabilities.

Gurgaon, India

• Dedicated to Quality and Service Excellence:Consistently adhered to ISO 2000 standards and ITIL processes to ensure exceptional service quality and customer satisfaction within a global IT team.• SQL Server Steward:Meticulously maintained all SQL databases, expertly executing administration and maintenance tasks to guarantee optimal performance and data integrity.• Versatile IT Generalist:Provided comprehensive support for a wide range of technologies, including Windows, AD, DHCP, DNS, Hyper-V, ESX VMware 4.0, FTP Server, BizTalk Server, VNC Terminal Server, network configuration, and software installation.• Security Champion:Rigorously implemented server hardening measures during installation and deployment to proactively address vulnerabilities and safeguard systems.• Antivirus Guardian:Oversaw Symantec and McAfee antivirus servers across all locations, ensuring timely virus definition updates and generating comprehensive daily reports to maintain a secure environment.

Gurgaon, India

 Windows Server 2008 installation, Active directory, FSMO, DHCP, DNS, printer installation, FTP Server, Software Installation, IP configuring, telnet services etc. Handle Exchange 2003 & 2007 server and clients Proper hardening of server while installing and implement server. Installation of Antivirus Server of all location.

Bachelor Of Arts (B.A.), Sanskrit & Rajasthani

Sql Dba And Itil Trained From Niit Limited, Information Technology

Activities and Societies: Taken SQL DBA and ITIL training for program'sTaken SQL DBA and ITIL training for program's

Professional Diploma In Computer Hardware And Networking, Information Technology, A

Activities and Societies: MCP Certified in windows server 2003 and Completed professional course in Hardware and networking from A-Set.

12, Art/Art Studies, General