Experience

AIS (Apex Infinite Solutions)
• United States
• Information Technology & Services
• 1 - 100 Employee
• SQL Database Engineer

  • Dec 2022 - Present


Freedom Mortgage

• United States
• Financial Services
• 700 & Above Employee

• Database Administrator

  • Oct 2017 - Dec 2022

  • Spearhead 450+ databases and VLDBs across several data centres and install and updates the SQL Server application. • Perform extensive database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016 and migrate on-premises SQL Data to Azure SQL Database. • Direct supply of 180+ SQL Server databases in production on clustered servers with 24x7 DBA and production support. • Participate in providing 500+ SQL Server Prime customers with configuration, administration… Show more • Spearhead 450+ databases and VLDBs across several data centres and install and updates the SQL Server application. • Perform extensive database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016 and migrate on-premises SQL Data to Azure SQL Database. • Direct supply of 180+ SQL Server databases in production on clustered servers with 24x7 DBA and production support. • Participate in providing 500+ SQL Server Prime customers with configuration, administration, implementation, and troubleshooting support for Business workflow with the Log Shipping method, portraying strong communication skills. • Conduct 5+ database refresh activities from staging and development servers to production servers. • Orchestrate planned backup and restore procedures and create logins, users, groups, roles, jobs, alerts, and emails confirming tasks per standards, showcasing robust leadership skills. • Coordinate on-call mission-critical environments and operate 2 distinct databases: the Disaster recovery database and the read-only reporting database. • Solve 100% of the SQL Server issues following SLAs, requiring in-depth expertise in the architecture, connection, replication, backup/restore, security, and ongoing enhancement of SQL Server. • Integrate NetMon for monitoring and performing network throughput issues and arrange database auditing and transaction performance with PerfMon and SQL Profiler. Show less • Spearhead 450+ databases and VLDBs across several data centres and install and updates the SQL Server application. • Perform extensive database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016 and migrate on-premises SQL Data to Azure SQL Database. • Direct supply of 180+ SQL Server databases in production on clustered servers with 24x7 DBA and production support. • Participate in providing 500+ SQL Server Prime customers with configuration, administration… Show more • Spearhead 450+ databases and VLDBs across several data centres and install and updates the SQL Server application. • Perform extensive database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016 and migrate on-premises SQL Data to Azure SQL Database. • Direct supply of 180+ SQL Server databases in production on clustered servers with 24x7 DBA and production support. • Participate in providing 500+ SQL Server Prime customers with configuration, administration, implementation, and troubleshooting support for Business workflow with the Log Shipping method, portraying strong communication skills. • Conduct 5+ database refresh activities from staging and development servers to production servers. • Orchestrate planned backup and restore procedures and create logins, users, groups, roles, jobs, alerts, and emails confirming tasks per standards, showcasing robust leadership skills. • Coordinate on-call mission-critical environments and operate 2 distinct databases: the Disaster recovery database and the read-only reporting database. • Solve 100% of the SQL Server issues following SLAs, requiring in-depth expertise in the architecture, connection, replication, backup/restore, security, and ongoing enhancement of SQL Server. • Integrate NetMon for monitoring and performing network throughput issues and arrange database auditing and transaction performance with PerfMon and SQL Profiler. Show less



St.Vincent Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Sql Server Database Administrator

  • Sep 2014 - Oct 2017

  • Employed SQL Server 2005 through 2014 database environments for MS SQL Server design, development, and management. • Executed SQL Server Installation, Configuration, and Upgrade and recorded SQL health checks, spotted problems and resolved 100% of them to avoid issues, demonstrating efficient management skills. • Utilized SQL Indexes to reduce storage and maintenance costs and improve query performance. • Applied 4 optimization tools for monitoring and fine-tuning SQL Server… Show more • Employed SQL Server 2005 through 2014 database environments for MS SQL Server design, development, and management. • Executed SQL Server Installation, Configuration, and Upgrade and recorded SQL health checks, spotted problems and resolved 100% of them to avoid issues, demonstrating efficient management skills. • Utilized SQL Indexes to reduce storage and maintenance costs and improve query performance. • Applied 4 optimization tools for monitoring and fine-tuning SQL Server performance, including SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor. • Oversaw daily administrative tasks, including setting up schedules and jobs, generating alerts using SQL Server Agent for job monitoring and troubleshooting, and sending Database Mail to notify users of events. • Allocated 5 logins, server and database roles, and server permissions to ensure server security. • Administered high availability features like Clustering, Always On, Log Shipping, Database Mirroring, and Replication. • Drafted 4 reports about keeping database response times in a 24X7 production environment and performing disaster recovery and backup/restore of databases. • Supervised Log Shipping from Primary to Standby servers and developed SQL objects such as constraints, views, stored procedures, and user-defined functions. Show less • Employed SQL Server 2005 through 2014 database environments for MS SQL Server design, development, and management. • Executed SQL Server Installation, Configuration, and Upgrade and recorded SQL health checks, spotted problems and resolved 100% of them to avoid issues, demonstrating efficient management skills. • Utilized SQL Indexes to reduce storage and maintenance costs and improve query performance. • Applied 4 optimization tools for monitoring and fine-tuning SQL Server… Show more • Employed SQL Server 2005 through 2014 database environments for MS SQL Server design, development, and management. • Executed SQL Server Installation, Configuration, and Upgrade and recorded SQL health checks, spotted problems and resolved 100% of them to avoid issues, demonstrating efficient management skills. • Utilized SQL Indexes to reduce storage and maintenance costs and improve query performance. • Applied 4 optimization tools for monitoring and fine-tuning SQL Server performance, including SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor. • Oversaw daily administrative tasks, including setting up schedules and jobs, generating alerts using SQL Server Agent for job monitoring and troubleshooting, and sending Database Mail to notify users of events. • Allocated 5 logins, server and database roles, and server permissions to ensure server security. • Administered high availability features like Clustering, Always On, Log Shipping, Database Mirroring, and Replication. • Drafted 4 reports about keeping database response times in a 24X7 production environment and performing disaster recovery and backup/restore of databases. • Supervised Log Shipping from Primary to Standby servers and developed SQL objects such as constraints, views, stored procedures, and user-defined functions. Show less