Sql Server Database Administrator

Grace Jegede

Davis, CA *****.******@*******.*** : 530-***-****

DATABASE ADMINISTRATOR

Professional Summary

●Seasoned Database Professional with over 8 years of experience managing mission-critical databases, both on-premises and in the cloud (Azure).

●Expertise in SQL Server Management Studio (SSMS), performance tuning, maintenance, and High Availability and Disaster Recovery (HADR) strategies.

●Hands-on experience with setting up and troubleshooting AlwaysOn Availability Groups, Failover Clustering, Database Mirroring, Log Shipping, and various Replication models to include snapshot, transactional, and merge.

●Proficient in database backup and recovery, query optimization, SQL Server installation, and configuring both standalone and clustered environments.

●Skilled in migration and upgrades, applying service packs, and performing routine DBA tasks such as health checks, index optimization, updating statistics, client/server connectivity, and capacity planning.

●Adept at securing SQL Server through user management, assigning roles and permissions, and implementing advanced database security measures such as transparent database encryption (TDE) and dynamic data masking.

●Experienced in leveraging tools like Query Store, Extended Events, Database Engine Tuning Advisor (DTA), SQL Profiler, custom scripts, and third-party tools (e.g., ServiceNow, SolarWinds, SQL Sentry) to diagnose and resolve performance bottlenecks, deadlocks, and slow-running queries.

●Extensive experience working with Active Directory (AD) for object and user permission management.

●Participated in a team development using JIRA.

●Knowledge of data integration (e.g., extract, transform, and load (ETL) processes).

●Familiarity with data transport protocols (e.g., SFTP, XML, JDXDML).

SQL Server Database Administrator

Chime (Contract) February 2019 - Present

DataNtc is a Tech consulting company in New York, USA, providing innovative IT solutions to clients from various industries including banking, finance, Insurance, Oil and Gas, Manufacturing etc.

Responsibilities

●Managed over 500 databases, including Very Large Databases (VLDBs), across multiple data centers.

●Participated in technical decision-making for business requirements, collaborating with Business Analysts, client teams, and development teams while performing capacity planning and SQL Server upgrades.

●Migrated SQL data from on-premises environments to Azure SQL Database.

●Designed and maintained High Availability and Disaster Recovery (HADR) solutions, leading large-scale migrations from SQL Server 2005 to SQL Server 2012R2, 2014, and 2016.

●Performed physical and logical data modeling for databases of varied sizes, including VLDBs.

●Delivered 24x7 DBA and production support for over 180 SQL Server databases on clustered servers.

●Assisted SQL Server prime customers with configuration, administration, implementation, and troubleshooting of business workflows using log shipping mechanisms.

●Configured disaster recovery solutions with transaction replication, including multiple updatable subscriptions from a distribution server.

●Conducted database refresh tasks from production to development and staging servers.

●Executed scheduled backups and restore operations to ensure data safety and availability.

●Created and managed SQL Server objects such as logins, users, groups, roles, jobs, alerts, and configured email notifications for task completion.

●Performed database consistency checks using DBCC, defragmentation, and index tuning while actively monitoring error logs.

●Provided on-call support for mission-critical environments, ensuring rapid resolution of issues and expertise in disaster recovery mechanisms.

●Troubleshot SQL Server problems in alignment with SLAs, leveraging in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, and security.

●Maintained specialized databases, including read-only reporting databases and disaster recovery databases.

●Managed security tasks such as granting and revoking permissions to maintain data security and compliance.

●Conducted auditing and resolved transactional database issues using tools such as PerfMon, SQL Profiler, and NetMon for monitoring and addressing network throughput challenges.

SQL Server Database Administrator

TJX Companies (Contract) March 2015 - Jan 2019

●Designed, developed, and administered MS SQL Server databases across environments ranging from SQL Server 2005 to 2014.

●Monitored SQL Server health checks to identify and resolve performance issues.

●Utilized SQL Indexes to enhance query performance, reduce storage requirements, and minimize maintenance costs.

●Leveraged optimization tools such as SQL Profiler, Dynamic Management Views (DMVs), and Windows Performance Monitor for performance tuning and monitoring.

●Installed, configured, and upgraded SQL Server instances to support business requirements.

●Gained extensive experience in user management and maintaining robust databases.

●Automated administrative tasks by creating jobs, schedules, and alerts using SQL Server Agent, while monitoring and troubleshooting job failures and event notifications via Database Mail.

●Ensured server security by managing logins, server and database roles, and permissions.

●Implemented disaster prevention and recovery strategies while supporting High Availability features such as clustering, Always On Availability Groups, Log Shipping, Database Mirroring, and Replication.

●Maintained database response times in a 24x7 production environment and proactively generated performance reports.

●Planned and executed database backup/restore operations and disaster recovery plans.

●Configured and managed log shipping between primary and standby servers.

●Created and maintained T-SQL objects, including tables, views, stored procedures, constraints, and user-defined functions.

●Used tools like SQL Profiler, Foglight, and Red Gate to monitor and optimize the database environment.

Education & Trainings

Bachelors of Science: Obafemi Awolowo University, Osun state, Nigeria 2007-2011

Certificate of Completion: Eductech Lagos Nigeria 2012-2014

References: Available on Request.

Contact this candidate