Charulata Mathur

Allianz Technology of America (Minneapolis, MN, USA), SQL Server Administrator, and Developer, Oct 2019 - Current

• Serving as a Project Manager, Senior DBA, and developer, managing scope, schedule, budget, and performance.
• Database developer and administrator (DBA) with extensive experience designing, coding, testing, and supporting next-generation database solutions in SQL Server environments.
• Report query development, report authoring, and tuning.
• Performance Tuning and Optimization (PTO) & Capacity Monitoring.
• Extensive experience in writing T-SQL queries, stored procedures, triggers, etc.
• Strong query and performance analysis.
• Expertise in IDERA.
• SQL Server version upgrade from 2008 to 2019.
• Working experience with SSIS and SSRS.
• SQL Server Installation and Configuration.
• Data Security, Backup & Recovery, Standby/Failover Administration, and Disaster Recovery (DR)
• Extensive experience in clustering, high availability (HA), and Always On environments.
• Worked on maintenance plans, agent jobs, log shipping, replication, and mirroring.
• Extensive experience in CA Workload Automation.
• Troubleshot complex SQL queries to identify problems or potential improvements in performance.
• Optimized storage and archiving practices to manage database size and performance.
• Worked with cross-functional teams to achieve goals.
• Hands-on experience with PowerShell, SQL scripting, and SQL Server PowerShell modules.

Allianz Global Investors (Gurgaon, India), SQL Server Database Administrator and Developer, July 2014 - March 2019.

• Served as a Team Lead and DBA, managing scope, schedule, customer, and performance.
• Involved in the most critical application: the Middle Layer, which looks into the smooth flow of trades from Bloomberg to a third party.
• Developed and performance-tuned SQL Server scripts and reports for the AGI application process, which involved managing real-time trades and assets of clients.
• Data Security, Backup & Recovery, Standby/Failover Administration, and Disaster Recovery.
• Worked on clustering, Always On environment, log shipping, replication, and mirroring.
• Extensively worked on maintenance plans, agent jobs.
• Extensively worked on maintenance plans and agent jobs.
• Using the Bloomberg Professional tool for analyzing various trades and messaging.
• Migration of Oracle to Microsoft SQL Server, and validation of involved DB components.

Royal Bank of Scotland (Gurgaon, India), SQL Server Developer, Aug 2012 - Jun 2014.

• Worked in AML (Anti Money Laundering) and FQA (Filter Quality Assurance) on client screening and assurance of the client screening process.
• Developed Linux/SQL scripts to develop and enhance these processes.
• Closely worked at the customer location in the development of project requirements, specifications, and design documents.
• Provided guidance on test scenarios, reviewed test cases, and ensured coverage of testable requirements.
• Assisted the Project Manager, provided project coordination, tracking, and reporting.
• Implemented complex queries to retrieve data from the SQL Server database by joining multiple tables with different conditions.

Micron (Numonyx) Technology (Noida, India), SQL Server, and Unix Developer, Jun 2010 - Aug 2012.

• Designed, developed, and maintained Unix/SQL scripts for various applications.
• Preparation of extensive test cases and test scenarios covering every aspect.

Initial Learning Program (Noida/Bhubaneswar, India), Trainee, Dec 2009 – Jun 2010.

• Extensive initial training on Project development, Unix, PL/SQL