ROMAN ARAGAW

SENIOR SQL SERVER DBA

CONTACT

702-***-****

ad4ztf@r.postjobfree.com

www.linkedin.com/in/roman-aragaw

SUMMARY

Experienced SQL Server DBA with nearly 7 years of expertise in optimizing complex database environments. My expertise includes high-performance database design, security, and availability. I handle backups, restores, and performance tuning, leveraging deep knowledge of indexing and query optimization. I troubleshoot and resolve issues, ensuring efficient solutions and minimal downtime. Skilled in monitoring and maintaining SQL Server instances for optimal functionality.

EDUCATION

Bachelor of Science

Business education

Aug 2006

KEY SKILLS

T-SQL

PL/SQL

PowerShell

Redgate

Jira

ServiceNow

SQL Server Management Studio

SSIS

ETL

Database Tuning advisor (DTA)

Windows Server 2022/2019/2016/2014/2012R2

SQL Server 2008/2012/2016/2017/2019/2022

High Availability

Disaster Recovery

SQL Server Agent Jobs

Auditing

Performance Tuning

Log Shipping

Monitoring

Change Tracking

Database Migration Tools

SQL Profiler

Replication

Index Maintenance

SSRS

Golden-Gate

Database Performance Tuning

Patch Management

Clustering

OLTP

Troubleshooting

Cloud Platforms

Database Design

Service Packs Installation

Schema Changes

Job Scheduling

EXPERIENCE

SENIOR SQL SERVER DBA

Apex Financial Consultants Jan 2022– Present

Excellent experience in installing, configuring, and administering SQL Server versions (2012 – 2022) enterprise, standard, developer, and express editions.

Demonstrated expertise in performance monitoring and tuning, alongside proficiency in query optimization, ensuring optimal client/server connectivity and database integrity with DBCC Utilities.

Contributed to database migration projects by assisting with data mapping, schema conversion, and application testing to ensure a smooth transition from legacy systems.

Troubleshoot performance issues by optimizing queries, managing tempdb and rapid log file growth, and addressing locks, blocks, and deadlocks.

Configured log-shipping, mirroring, and SQL Server failover clustering, including AlwaysOn availability groups, to ensure robust disaster recovery solutions.

Utilized SQL Server's CDC feature to track all changes during data migration between databases.

Excellent communication skills, decision making and analytical skills.

Collaborate with application developers to monitor and optimize application performance from database side.

Possess a deep understanding of SQL Server administration, leveraging Redgate tools for comprehensive monitoring and management.

Developed and used standard operating procedures (SOPs) to ensure database availability, robust performance, and security.

Managed SQL Server environments adhering to strict SLAs, while effectively defining and meeting RPO and RTO objectives to ensure business continuity and data availability.

Successfully migrated data from SQL Server to Oracle Database using GoldenGate, ensuring seamless data integration and synchronization between platforms.

Designed the database backup and recovery strategy, created backup schedules and maintenance jobs, and monitored the backups to ensure completion within the designated time.

Developed and used stored procedures and PowerShell scripts for database automation.

Supervised and mentored junior DBAs.

Provided 24/7 production database on-call support.

SQL SERVER DBA

Bank of Nevada Jan 2019 – Dec 2021

Skilled in installing, upgrading, maintaining, and configuring the SQL Server Suite, including SSIS and SSRS services.

Refreshed various database environments to support ongoing projects as required by clients, ensuring timely and efficient data updates.

Managed and configured SQL Server Agent jobs to automate routine tasks, ensuring efficient database maintenance and operation.

Installed and configured SSRS for advanced reporting and data analysis.

Created server logins, database users, and custom database roles,

as well as assigned users to specific roles to control access to data.

Specialized in query optimization, dramatically improving SQL Server's query response times and overall performance.

Implemented SSIS for robust ETL processes, enhancing data migration, integration, and transformation efficiencies.

Migrated databases to new servers, ensuring data integrity and minimizing downtime.

Provided training to non-technical users and addressed technical support inquiries.

Monitored real-time database events with Change Data Capture (CDC) tool, recording them into the database.

Participated in an after-hours on-call rotation, providing support for monitoring, installations/patches, migrations, and other tasks alongside team members.

Performed online transactional processing (OLTP).

Optimized database access and strategically allocated resources to ensure peak performance and cost-efficiency in database configurations.

Resolved database performance issues through meticulous index maintenance, statistics updates, and conducting database consistency checks.

Managed incident and service request activities using ticketing systems like ServiceNow and Jira, ensuring efficient resolution and tracking.

Utilized Database Engine Tuning Advisor, Activity Monitor, Extended Events, system stored procedures, DMVs, and trace flags for monitoring and tuning database performance.

Junior SQL SERVER DBA

Dept of Education (UOA) May 2017 – Dec 2018

Installation, configuration, administration and, maintenance of SQL server instances.

Maintained data integrity with thorough validation checks.

Implemented strategic table partitioning techniques to enhance database performance, streamline maintenance processes, and increase data availability, contributing to improved system efficiency and user access.

Conducted performance tuning of indexes and databases overall, including query optimization, table partitioning, and database schema design.

Implemented and maintained backup and recovery procedures to ensure data integrity and minimize downtime, using tools such as SQL Server Agent and third-party backup solutions.

Leveraged troubleshooting tools such as SQL Profiler, Activity Monitor, DMVs, and wait stats to diagnose and resolve performance issues and optimize system resources.

Performed routine database maintenance tasks on a daily, weekly, and monthly basis, ensuring optimal database performance and reliability through systematic checks and optimizations.

Proactively managed the regular patching and upgrading of the database system; carefully evaluated the potential impact of proposed updates on the existing database environment and seamlessly integrated these updates to minimize disruption.

Contact this candidate