Microsoft Solutions Expert in both data platform and data management & analytics with extensive experience in designing, coding, testing and supporting next-generation database solutions in Microsoft SQL Server, MySQL, P…
Microsoft Solutions Expert in both data platform and data management & analytics with extensive experience in designing, coding, testing and supporting next-generation database solutions in Microsoft SQL Server, MySQL, PostgreSQL and Oracle environments. Over 16 years industry experience with proficiency in an assortment of technologies, platforms and tools, including AWS RDS, Azure, Windows, Mac, Linux, CentOS, HDFS, Map Reduce, Hive, Sqoop, Impala, MongoDB, SQL Server Data Tools, SSRS, SQL Server Agent, SSIS, Informatica Power Mart, Ms Access, SQLite, Teradata and MS Office .
Designing schema, access patterns, locking strategy, SQL development, and tuning.
Modifying the database structure.
Optimizing application and end-user queries (reactive tuning)
Generating needed ad hoc reports by querying from the database
Proactive performance tuning
Enrolling users and maintaining system security
Parameter configuration and tuning
Cache management
Alerting
Setting up, administering, and controlling RDS instances and their read replicas on AWS.
Parameter configuration and performance tuning.
Monitoring performance metrics, response times, and request rates.
Enrolling users and maintaining system security.
Ensuring constant database support, assistance to developers, technical support, and business clients.
Setting up ProxySQL using helm.
Checking services/pods logs to debug the application-level issues.
Setup ProxySQL and routed read commands to different host groups.
A quick copy process for databases on EC2 jump servers was developed.
Identified and resolved the issues with a legacy database system; work effort was reduced by 70%.
Manage SQL database administration assignments for business clients.
Enhance database performance.
Perform restores.
Implement recovery procedures.
Conduct regular system backups.
Ensure technical and functional designs meet business requirements.
Provide plan and advancement help to application engineers, business analysts and business clients by guaranteeing consistent database help and backing.
Ensured the access control and configuration of the system satisfied the business guidelines and customer needs.
Managed and monitored applications and systems around the clock by developing automated alerts & warnings for potential failures.
Effectively and efficiently managed over 8 terabytes database and ensured the downtime reduced by proposing best approach during the rollout plans.
Improved users’ comprehension of database systems by conducting pre-execution workshops, delivering group and individual training sessions and authoring user-friendly training materials.
Awarded with bonus for designing a web-application in a short span of period that contains logical reports and dashboard with no overhead to the organization.
Dealt the project single handedly from starting the discussions, planning, execution, and functionality testing to deployment.
Within 48 hours, spearheaded the installation of the SSRS and PBRS on-premises server environments.
Dynamic team member in SQL consolidation Project.
Administration of SQL Server staging and MySQL & PostgreSQL Production environments.
Analysis on the historical data.
Understand the priorities and assigning the work-load efficiently to the team members and meet the deadlines.
Succeeded in providing excellent data insights to the management to take the right decision for the business improvement.
Enthusiastically involved in database development.
Created database objects such as databases, dynamic tables, creating reusable stored procedures, functions, cursors, triggers and views.
Innovated the fundamental dashboards to be shown on enormous screens for the call center to spare their efforts by 15%.
Chairperson to the quarterly access control review meetings.
Saved my team's endeavors by 50% by distinguishing the continuous issues and the regular reports and fixing and automating them.
Also, developed ETL solutions for complex projects.
Spared 30% worker hours by introducing and automating the dynamic end user account statements for the Operations teams.
Engaged with RCA for the application issues and data fixes and provided the most ideal solutions.
Troubleshoot the application and database issues and provide technical support to the customer support teams.
Technical assistance to the developers and restoring the databases in staging and testing environments as requested.
Appliance the business rules by writing stored procedures.
Highly involved in developing and documenting the standards, policies, procedures and key performance metrics that support the continued progress of IT administrations.
Point of contact to the internal and external auditors.
Mentored over 15 employees and assisted them with professional issues.
100% succeeded in bringing back the MySQL database online when it crashed.
Production and reporting servers maintenance and administration.
Assist with development of standards of L1 and L2 teams and policies around data /access security (end-user access vs dev access).
Explored and analyzed the data in detail and recognized the fraudulent activities while buying credit using Credit Card, Paypal and Money Bookers.
Implemented a solution using stored procedures and functions in MySQL databases to control such exercises.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
