Application Database Administrator

• Feb 2023 - Present

Saas Technical support

• Dec 2022 - Feb 2023

• Provide Tier 1 software support for our clients by troubleshooting and maintaining frontend and backend systems on AWS. • Multi-task and track dozens of open tickets at various stages of completion. • Work with multiple teams to find, analyze, and resolve client issues. • Communicate the root cause to clients in non-technical terms. • migrate Data from on-prem to AWS RDS and EC2 • checking errors on Kubernetes and containers, pushing new updates on git • Proactively identify clients experiencing repeated issues or requests that are not resolved to the client’s satisfaction. Escalate issues, as needed. • Provide recommendations to the Product team about how to improve customer experience. • Work closely with the Customer Success Managers to maintain continuous knowledge of accounts.

Senior Database Administrator

• Nov 2019 - Oct 2022

• Monitors and ensures all ECX business, corporate, and market data dissemination databases including SMS/IVR databases on MYSQL are properly functioning, optimized, and highly available and secured. • Install, and maintain Database software and updates (MSSQL, MySQL) • Audit Database Access and Requests • Analyze the Impact of Database Changes on the Business • Analyze and Recommend Database Improvements • Debug Database Issues on Live Data • Design and Build Database Management System • Implement a Backup and Recovery Plan • Proactively Tune Database in Production • Test Database to Ensure Everything Operates Efficiently Without Error, Test Recovery Plans • Set Security Permissions for the Database, Setup Safety Measures to Recover Data • Setup Safety Measures to Recover Data • Oversees and conducts restoration of ECX’s business databases, and ensures the backup of the eTrade Application database and all business Critical databases of the Exchange and the restoration and recovery of corrupted business databases. • Participates in recommending the most effective way to increase database performance including hardware purchases, server configuration changes, and query tweaking or index/query changes • Ensures for all the ECX database policies and standards are followed on ECX database infrastructure. • Monitors the proper functioning of the ECX Database infrastructure at all time on working and non-working hours, locally and remotely and daily ensures primary and disaster recovery site databases are synchronized • Participates and assists Application developers on efficient database design, Updates eliciting business requirements, and database development • Ensures that new database code meets ECX database policy and standards for readability, reliability, security, and performance • Provides Tier III support to resolve database administration-related tasks

Broadcast Scheduler (Power BI Developer)

• Feb 2016 - Feb 2019

• Develop and Maintain programming logs, as required by station management and the Federal Communications Commission.(DATABASE BASED) • Preview scheduled programs to ensure that signals are functioning and programs are ready for transmission. • pre-production planning monthly show grid. • Select sources from which programming will be received, or through which programming will be transmitted. • Report equipment problems, and ensure that repairs are made; make emergency repairs to equipment when necessary and possible. • Observe monitors and converse with station personnel in order to determine audio and video levels and to ascertain that programs are airing. • Substitute programs in cases where signals fail. • Organize recording sessions. • Perform preventive and minor equipment maintenance, using hand tools. • Power BI Report development. • Building Analysis Services reporting models. • Developing visual reports, KPI scorecards, and dashboards using Power BI desktop. • Connecting data sources, importing data, and transforming data for Business intelligence.

Database Administrator

• Oct 2015 - Jan 2016

• Providing SQL expertise, proposing design recommendations and optimization • Providing and designing information tools to assist in the management of business lines • Supporting data analysis inquiries from business partners and presenting results • Identifying and resolving database performance issues • Developing security schemes for database environments as well as assisting in disaster recovery as necessary • Analyzes document flow; researches and resolves DBMS processing errors. • Plans, sets up, tests and implements DBMS processes for new DB. • Acts as a liaison to external and partner hospitals to ensure timely problem resolution and transaction testing. • Along with IT team, working with vendors in evaluating and implementing new technologies • Supporting users by conducting training; providing information; resolving problems. • Supporting database functions by designing and coding utilities. • Providing occasional PC support • Managing Database support teams and evaluating performance metrics