Summary
Overview
Work History
Education
Skills
Timeline
Generic

OCTAVIAN CANDIDUS

Henderson,NV

Summary

Experienced SQL Server Database Administrator with over 10 years of expertise in managing and optimizing large-scale, mission-critical databases. Skilled in performance optimization, high availability, data security, replication, and disaster recovery planning.

Recognized for problem-solving abilities and a collaborative approach, fostering efficient operations across cross-functional teams.

Specialized in database optimization and SQL tuning, with a proven track record of driving organizational efficiency and ensuring reliable, secure database performance. Dedicated to delivering high-quality results and maximizing productivity.

Overview

11
11
years of professional experience

Work History

APPLICATION DATABASE ADMINISTRATOR

Accenture Federal Services
Henderson, NV
01.2024 - Current
  • Managed Azure SQL Databases and SQL Managed Instances, optimizing configuration, performance tuning, and high availability for cloud-based applications
  • Designed and implemented solutions such as AlwaysOn Availability Groups, Geo-Replication, and Azure SQL Auto-failover groups, ensuring data availability and business continuity
  • Strengthened database security with Azure SQL Vulnerability Assessments, Advanced Threat Protection, and firewall configurations to meet industry standards
  • Proactively monitored on-premises and Azure SQL databases using Azure Monitor, SQL Insights, and Diagnostic Manager, resolving latency and query performance issues
  • Analyzed resource utilization to forecast database growth and implemented auto-scaling for Azure SQL Databases to ensure optimal performance and cost efficiency
  • Assessed and remediated vulnerabilities using Azure Security Center, ensuring timely updates and adherence to organizational policies
  • Designed and managed backup strategies with Azure Backup and Point-in-Time Restore, guaranteeing quick recovery during failures or disasters
  • Partnered with development teams to deploy database schema changes via GitHub and Azure DevOps pipelines, enabling seamless CI/CD processes
  • Automated routine database management tasks such as indexing, backups, and performance tuning using Azure Automation and Logic Apps, enhancing efficiency and scalability
  • Configured security auditing with Azure SQL Auditing and Advanced Threat Protection, enforcing access controls and ensuring regulatory compliance
  • Worked alongside DevOps teams, cloud engineers, and developers to optimize databases and implement best practices in performance and security
  • Managed Azure SQL Elastic Pools, optimizing resource allocation and reducing operational costs across multiple databases

SENIOR SQL SERVER DATABASE ADMINISTRATOR

Cognizant Technologies Corp
Plano, TX
07.2022 - 01.2024
  • Database design, Modeling Query tuning
  • Performance monitoring SQL Profiler
  • DTA (Database Tuning Advisor)
  • SolarWinds DPA SQL Sentry Idera
  • Database mirroring, Log shipping, Clustering
  • AlwaysOn Availability Groups, Replication
  • Azure SQL Database, AWS RDS
  • Microsoft Hyper-V, Citrix, VMware
  • Database encryption (TDE), Data masking
  • SQL audits, Table/row-level security
  • Power BI, Azure Synapse, Databricks
  • PowerShell, Active Directory management, GitHub, JIRA, Terraform etc

MICROSOFT SQL SERVER DBA

Ameris Bank
Los Angeles, CA
05.2020 - 07.2022
  • Managed high-availability databases by implementing replication, encryption protocols, backups, and disaster recovery plans, ensuring consistent uptime and data integrity
  • Configured and monitored performance metrics on Azure servers, leveraging tools like SQL Enterprise Manager and SolarWinds DPA to ensure high availability and optimal performance
  • Oversaw updates and enhancements through clear communication with clients and teams, minimizing downtime during seamless database transitions
  • Administered security policies and audits, establishing multi-layered access controls at server, table, and row levels, aligning operations with compliance requirements
  • Scheduled maintenance and managed SQL Agent jobs to proactively address performance issues and support future scalability
  • Maintained secure and reliable data operations for financial and ERP systems, critical to business functions
  • Led code reviews and collaborated with developers to optimize SSIS/DTS packages and T-SQL queries, ensuring performance best practices
  • Configured high-availability architectures, including AlwaysOn Availability Groups, and developed comprehensive backup and recovery strategies
  • Planned and executed SQL Server upgrades from 2012 to newer versions (2014, 2016, 2019), conducting extensive testing for smooth transitions
  • Performed health checks, managed SQL Agent jobs, and resolved user access requests to maintain stability across production environments
  • Designed and managed data warehouse solutions, implementing best practices for secure and efficient data retrieval

SENIOR MICROSOFT SQL SERVER DBA

Delicato Family Vineyards
Manteca, CA
07.2015 - 05.2020
  • Provided around-the-clock technical support for SQL database systems in a time-sensitive food industry environment, ensuring consistent reliability and uptime
  • Upgraded SQL Server environments from 2008/2008R2 to 2016, applying critical service packs to maintain system security and performance
  • Resolved deadlocks and optimized query performance using SQL Profiler and transaction isolation level adjustments
  • Configured high-availability solutions like clustering, log shipping, replication, and AlwaysOn Availability Groups to minimize downtime
  • Conducted regular data migrations between production, development, and staging servers, ensuring data consistency and reliability for testing
  • Enhanced database functionality by conducting performance analysis with tools like DTA, SQL Profiler, and Performance Monitor
  • Worked with developers to optimize SSIS/DTS packages, stored procedures, and queries, ensuring efficient and scalable applications
  • Planned and executed migrations from SQL Server 2012 to newer versions, testing thoroughly to ensure stability and smooth transitions
  • Managed maintenance schedules and SQL Agent tasks to ensure efficient automation and future scalability

MICROSOFT SQL DATABASE ADMINISTRATOR

Advance College
Los Angeles, CA
04.2014 - 07.2015
  • Provided 24/7 primary DBA support for education systems, ensuring uninterrupted service and timely resolution of critical issues
  • Implemented SQL auditing policies and compliance measures to meet SLAs and regulatory standards
  • Conducted in-depth analysis of memory, CPU, and disk usage to optimize resource allocation for current needs and future scalability
  • Scheduled full, differential, and transaction log backups, implementing robust disaster recovery strategies
  • Enhanced T-SQL performance using tools like Execution Plans, Database Tuning Advisor, DMVs, and DMFs for efficient database operations
  • Facilitated seamless migrations across development, QA, and production environments, ensuring data accuracy and smooth transitions
  • Partnered with development teams to create optimized stored procedures and documented database processes for knowledge sharing and streamlined operations
  • Developed and tested backup, restoration, and failover processes to ensure data resilience in case of outages
  • Trained personnel on efficient system usage while maintaining detailed run books and operational documentation for database management

Education

MASTER OF SCIENCE - INFORMATION TECHNOLOGY

Clark University
Worcester, Massachusetts
09.2013

BACHELOR OF SCIENCE - COMPUTER SCIENCE AND TELECOMMUNICATION

Lodz University of Technology
05.2011

Skills

Database Administration and Management

  • Microsoft SQL Server (2005–2022)
  • Always On Availability Groups, Log Shipping, Replication, Clustering, and Database Mirroring
  • Capacity Planning, Backup, and Recovery Solutions
  • Query Performance Enhancement and Optimization
  • Index Management Strategies
  • Database Security
  • Data Encryption (TDE)
  • Data masking
  • Table/Row-Level Security
  • SQL Audits
  • Database Monitoring Tools
  • SolarWinds DPA
  • SQL Sentry
  • Idera

Cloud Platforms

  • Azure SQL Database
  • AWS RDS
  • Data Integration and Warehousing:
  • Azure Synapse
  • Databricks
  • Power BI

Virtualization Platforms

  • VMware vSphere
  • Microsoft Hyper-V
  • Oracle VM VirtualBox
  • Citrix Hypervisor (formerly known as XenServer)
  • Amazon Web Services (AWS) EC2 virtualization

Data Management and Modeling

  • Data Modeling and Database Design
  • ETL Processes and Data Integration
  • Data Warehousing Solutions

Development and Scripting

  • Transact-SQL (T-SQL)
  • Shell scripting
  • PowerShell
  • Visual Studio
  • Terraform for Infrastructure Automation

DevOps and version control expertise

  • Version Control Systems
  • GitHub
  • JIRA
  • Active Directory Management

Additional skills

  • SSIS, SSAS, and SSRS for data integration, analysis, and reporting
  • ITIL Framework knowledge for IT service management
  • Disaster Recovery Planning for High Availability and Business Continuity
  • Database auditing and security compliance

Timeline

APPLICATION DATABASE ADMINISTRATOR

Accenture Federal Services
01.2024 - Current

SENIOR SQL SERVER DATABASE ADMINISTRATOR

Cognizant Technologies Corp
07.2022 - 01.2024

MICROSOFT SQL SERVER DBA

Ameris Bank
05.2020 - 07.2022

SENIOR MICROSOFT SQL SERVER DBA

Delicato Family Vineyards
07.2015 - 05.2020

MICROSOFT SQL DATABASE ADMINISTRATOR

Advance College
04.2014 - 07.2015

MASTER OF SCIENCE - INFORMATION TECHNOLOGY

Clark University

BACHELOR OF SCIENCE - COMPUTER SCIENCE AND TELECOMMUNICATION

Lodz University of Technology

Similar Profiles

CREATE PROFILE
OCTAVIAN CANDIDUS