MEGHA BHATIA
Database administrator
ON
Summary
Experienced Database and System Administrator with a passion for optimizing architectural efficiency and enhancing performance. Seeking professor opportunities to integrate my multifaceted experience in database administration, development, and teaching. Committed to fostering academic growth, advancing technological innovation within the classroom and beyond, and supporting collaborative team objectives.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Solutions Analyst
Miller Thomson LLP
10.2023 - Current
- Monitored and optimized performance of LOB applications and SQL Server instances
- Enhanced monitoring systems by systematically adding detailed information on monitored queries and processes
- Ensured optimal database growth and index performance by implementing and maintaining appropriate maintenance plans across all production instances
- Oversaw database backup operations to ensure consistent completion and availability of restore points
- Maintained comprehensive documentation of production instances, including configurations, licensing, dependencies, and workflows
- Reviewed and refined security models across production, test, and development instances to balance information protection and operational efficiency
- Provided senior-level expertise for all LOB applications and database operations, participating in ongoing and project-based activities
- Reviewed and recommended/approving requests related to application enhancements and database operations from both internal and external stakeholders
- Conducted regular reviews of resource utilization to inform instance lifecycle management and annual resource planning
- Consolidated existing data integration operations into a central platform for improved management and efficiency
- Collaborated on integration/workflow platform development efforts, representing database operations and data flow
- Took ownership of key application offerings, managing their functional lifecycle, and continuously improving performance
- Engaged with stakeholders to determine solution requirements, scope, estimate project efforts, identify risks, and recommend mitigation measures
- Collaborated with technology partners to research and analyze current system capabilities and define technology solutions
- Assisted quality assurance teams in translating requirements and use cases into test conditions and expected results for various testing phases
- Ensured optimal performance of all production SQL Server instances and enriching monitoring systems with detailed query and process information.
- Created detailed documentation for implemented solutions, ensuring all relevant parties had access to necessary information for future reference or troubleshooting purposes.
Database Administrator and Change Manager
Utilismart Corporation
08.2022 - 09.2023
- Managed all aspects of database administration, optimization, and disaster recovery
- Ensured optimal performance through proactive tuning, index maintenance, and troubleshooting of SQL Server instances
- Installed, configured, and maintained multiple database management systems, including Oracle, MSSQL, and Azure
- Performed proactive data analysis and maintenance activities to meet the organization's needs for identifying, classifying, modeling, storing, and accessing information
- Administered and documented data backup and recovery plans, capacity plans, and security plans
- Created and maintained system documentation and diagrams to ensure accurate tracking of system configurations and changes
- Participated in IT audits and provided recommendations for improving controls and compliance with regulations and standards
- Investigated, troubleshooted, and resolved database, technical, and systems problems promptly
- Recommended and implemented solutions based on a thorough analysis of issues and their business implications
- Led detailed data design reviews and provided constructive feedback
- Automated data operations and implemented methods to store, organize, and present data effectively
- Collaborated with key stakeholders to define, analyze, and deliver requirements that align with business and end-customer needs
- Translated business requirements into detailed data design specifications
- Implemented database backup and recovery procedures to ensure minimal data loss and system downtime in case of a disaster, achieving 99.99% uptime
- Designed and implemented security measures for databases
- Built data solutions that require minimal maintenance or intervention from programmers or operations teams
- Stayed updated on industry trends and technologies through active participation in professional associations, practice communities, and individual learning
- Participated in on-call rotations and handled after-hours system issues as needed
- Implemented proactive monitoring processes to reduce system downtime by 75% and increase overall system availability to 99.9%
- Collaborated with cross-functional teams to identify and resolve performance bottlenecks, improving query response time by an average of 50%.
- Coordinated efforts between multiple departments during large-scale transformation initiatives, ensuring seamless execution from start to finish.
- Evaluated compliance with regulatory requirements, mitigating potential risks and protecting organizational reputation.
- Enhanced internal control systems by conducting thorough risk assessments and implementing effective audit recommendations.
Database Developer (Fullstack)
Tornado Software Pvt. Ltd
12.2018 - 04.2021
- Developed complicated SQL queries, tables with partitions, indexes, sub-queries, and nested queries, as well as functions, procedures, and triggers using various schemas to implement the application's business logic
- Developed and updated all documentation related to database technologies for the department
- Responsible for creating and maintaining the integrity of specific databases and reporting any issues
- Developed, optimized, and maintained a high database structure capable of storing a large amount of data
- Managed both back-end and front-end aspects of the development process
- Built applications for Software as a Service (SaaS) using PHP and integrated various design languages such as HTML, CSS, JavaScript, jQuery, JSON, and WordPress.
Tutor
Self Employed
08.2014 - 12.2019
- Provided constructive feedback on assignments, helping students improve their writing and problem-solving skills.
- Managed scheduling and logistics for group tutoring sessions, accommodating the diverse needs of participating students and their families.
- Conducted regular evaluations of curriculum materials, making recommendations for updates or revisions as needed to maintain relevance in today''s rapidly changing world.
- Utilized various assessment tools to evaluate student progress and adjust instruction accordingly for optimal results.
- Enhanced students'' understanding of subject matter by incorporating real-world examples into lessons.
Education
Master of Electrical and Computer Engineering - Software Engineering -
University of Western Ontario
Ontario, Canada05.2022
Bachelor of Computer Engineering - Software Engineering -
Gujarat Technological University
Gujarat, India05.2018
Skills
- Database: Oracle, MySQL, Azure, Snowflake
- Database Administration: Administration, Optimization, Disaster Recovery, Backup and Recovery, Capacity Planning, Security Implementation, SSIS,SSRS
- Operating System: Windows, Linux administration
- Frameworks and Tools: Oracle Enterprise Manager, SharePoint, VMware, WordPress, GitHub, Bootstrap, Google Data Studio, FileZilla, Cpanel
- Programming: JavaScript, SQL, PLSQL, Shell Scripting, Python, PHP, HTML, CSS, AJAX, JSON, jQuery, Perl
- Interpersonal Skills: Fast learner, passionate about new technologies, excellent written and communications skills, works exceptionally well under pressure
- Microsoft Office: Excel, Word, PowerPoint, Access
- Systems administration
- Policy compliance
- Regulations and compliance
Certification
- ISO 27001:2022 Internal Auditor - BSI
- Oracle Database 12c: Advanced SQL - LinkedIn Learning
- Oracle Database 19c: Advanced SQL - LinkedIn Learning
- DP 300 - Microsoft Administering Microsoft Azure SQL Solutions - MIcrosoft
Timeline
Solutions Analyst
Miller Thomson LLP
10.2023 - Current
Database Administrator and Change Manager
Utilismart Corporation
08.2022 - 09.2023
Database Developer (Fullstack)
Tornado Software Pvt. Ltd
12.2018 - 04.2021
Tutor
Self Employed
08.2014 - 12.2019
Master of Electrical and Computer Engineering - Software Engineering -
University of Western Ontario
Bachelor of Computer Engineering - Software Engineering -
Gujarat Technological University