Santosh Kumar D
Database Administrator\Architect\Manager
Hyderabad
Summary
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Background includes data mining, warehousing, and analytics. Proficient in machine and deep learning. Quality-driven and hardworking with excellent communication and project management skills.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Associate Consultant
HCL Tech
01.2024 - Current
- Developed strong relationships with clients, fostering trust and ensuring long-term partnerships.
- Managed multiple projects simultaneously while maintaining attention to detail, organization, and adherence to deadlines.
- Conducted regular reviews of operations and identified areas for improvement.
- Gathered, organized and input information into digital database.
- Optimized customer experience by delivering superior services and effectively troubleshooting issues.
- Proactively identified risks and developed contingency plans to minimize potential issues during project execution.
Technology Architect
Cognizant Technologies
04.2019 - 01.2024
- Applied creative problem-solving skills to address unique challenges in the architectural design process.
- Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
- Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
- Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.
- Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
- Served as an internal consultant for application developers, providing guidance on query optimization techniques that improved application performance significantly.
- Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
- Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
- Evaluated emerging technologies to identify opportunities for improving database operations and reducing costs.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
- Created and updated database designs and data models.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Tested programs and databases to identify issues and make necessary modifications.
- Created and implemented database designs and data models.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
- Conducted tests to identify issues and make necessary modifications.
- Coordinated with project management on database development timelines.
- Designed and developed analytical data structures.
- Set up and controlled user access levels across databases to protect important data.
- Modified databases to meet needs and goals determined during planning process.
- Built databases and table structures for web applications.
- Developed scripts and processes for data integration and maintenance.
- Implemented BI solution framework for business intelligence projects.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Developed and updated databases to handle customer data.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Installed and configured middleware in Linux and Windows environments.
- Implemented security measures to protect vital business data.
Oracle Database Administrator
TCS
10.2011 - 04.2019
- Developed monitoring dashboards to provide real-time insights into system health, performance metrics, and resource utilization.
- Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
- Developed custom scripts and PL/SQL procedures for efficient automation of routine tasks and data management operations.
- Improved database performance by optimizing SQL queries and implementing indexing strategies.
- Collaborated with cross-functional teams to ensure seamless integration of Oracle databases with various applications.
- Established effective communication channels between IT teams responsible for managing different aspects of the Oracle Database infrastructure.
- Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
- Maintained up-to-date documentation on database systems, ensuring accurate records of configurations, processes, and changes made over time.
- Participated in disaster recovery exercises, testing contingency plans to ensure minimal impact on business operations during emergency situations.
- Conducted regular performance audits, identifying areas for improvement and adjusting configurations as needed.
- Coordinated with vendors for hardware and software upgrades, ensuring timely implementation of new features and improvements.
- Assisted with database upgrades and migrations by performing user acceptance testing.
- Completed database migrations with [Software].
- Maintained [Type] department document tracking database to follow documents' migration through processing sequence.
- Oversaw database upgrade, backup, recovery and migration.
- Processed enrollments, terminations and employee changes for different benefit coverages in HR database and in different provider portals.
- Maintained database to monitor [Number] accounts payable for corporate customers and vendors.
- Prepared reports for templates and maintained compliance database.
- Researched complex issues across multiple databases and worked with support resources to resolve issues.
- Established and maintained databases to manage pertinent information for use in comprehensive analysis and forecasting.
Education
Master of Science - Electronics
Andhra University
Visakahapatanam 04.2001 -
Skills
Project Management
Backup and recovery
Disaster Recovery Planning
Patch management
Data Modeling
Data Guard Implementation
SQL Query Optimization
Oracle Exadata Management
Database Cloning
Oracle Enterprise Manager
Database Troubleshooting
Oracle RAC Administration
Grid Infrastructure Management
GoldenGate Implementation
High Availability Solutions
Memory Management
Schema Management
Incident Management
Data Migration
Agile Methodology
Disaster Recovery
Database Management
Data audits
NoSQL Databases
Systems administration
Database Administration
Linux Operating System
Project Planning
Project Management
Certification
ORACLE 11G OCA
Timeline
Associate Consultant
HCL Tech
01.2024 - Current
Technology Architect
Cognizant Technologies
04.2019 - 01.2024
Oracle Database Administrator
TCS
10.2011 - 04.2019
Master of Science - Electronics
Andhra University
04.2001 -