Database Administrator Sql Server
Resume:
VIKTOR NAUMOV
Germantown, MD 20874
240-***-**** (cell)
E-mail: ***********@*****.***
Summary of Experience:
Secret Clearance
Oracle 11g Certified Database Administrator
ITIL Certified
Oracle 12c Certified Database Implementation Specialist
Operations DBA
Backups and recovery
Data Guard
Real Application Clusters
Automatic Storage Management
Installations, upgrades, refresh and patching
Key Responsibilities:
Dhara Consulting April 2020 – August 2024
Oracle Database Administrator
Managed Oracle 11g, 12c and 19c databases running on Red Hat Linux and Solaris platforms for the Bureau of Consular Affairs of the Department of State
Administered Oracle RAC database instances running Oracle 12c and Oracle 19c on Red Hat Linux across development, test and production environments
Managed, monitored and optimized database performance utilizing tools such as AWR, ADDM, Explain Plan and SQL Trace
Administered database instances in the Cloud-based environments using utilities such as EC2, S3 and RedShift
Utilized database management tools such as DBArtisan, SQL Server Management Studio, pgAdmin and MongoDB Compass
Automated repetitive, manual database tasks using Shell Scripting
Installed, configures and maintained SQL Server 2014,2012 and 2008 R2 in development, test and production environment
Configures and maintained Fail-Over Clustering using SQL Server 2012
Experience in SQL Server AlwaysOn environment
Scheduled many jobs to automate different SQL Server database related activities including backup, monitoring database health, disk space, backup verification
Developed different maintenance plans for database monitoring
Setup jobs, maintenance plans for backups, rebuilding indexes, check server health, alert, notifications
Used Import/Export tool to export and import data from different sources like SQL Server database, flat file, CVS, Excel and many other data sources
Managed all Oracle installations to be STIG complaint
Security hardened databases to ensure security compliance across all environments
Created, upgraded and migrated both Oracle 11g and Oracle 12c databases
Managed SQL Server databases as well as database backups and transaction log backups and performance
Performed Golden Gate installation and configuration in development, test and production environments
Created Data Guard databases and maintained their synchronization on an ongoing basis
Engaged in SQL and PL/SQL development as well as database and performance tuning working with development teams
Backed up and recovered databases to alleviate operational issues and to ensure system uptime
Collaborated with the development and application teams in script, code reviews and deployed application scripts across development, test and production environments
Assisted in database patching to remediate security vulnerabilities and ensure system operational stability
Actionet
Oracle Database Administrator January 2020 – April 2020
Administered Oracle 11g, 12c and 19c databases for the Bureau of Consular Affairs of the Department of State ensuring complete database accessibility and recoverability
Assisted application teams in regular code reviews, application deployments and data migrations across the entire infrastructure
Created and maintained database objects such as tables, views and indexes using SQL and PL/SQL techniques.
Performed SQL and PL/SQL tuning improving database response times and alleviating performance bottlenecks
Maintained Oracle 12c and Oracle 11g standby databases by ensuring database synchronization. Intervened as necessary to repair and resume database operations on an ongoing basis.
Managed a live ticket system view; worked on and updated the incoming requests and assignments in a proactive manner
Agreeya Solutions
Oracle Database Administrator November 2019 – January 2020
Provided full-life cycle database management to Verizon’s on-prem and in-cloud database systems
Managed database creations, upgrades and migrations for both internal and external customers
Utilized OEM and RMAN backup recovery techniques and procedures to restore and recover databases across development, test and production environments
Collaborated in efforts to maintain peak systems by analyzing AWR performance reports and adjusting database parameters as necessary
Followed-up with customers and management to ensure database availability and top performance on an ongoing basis
Tundra Federal
Oracle Database Administrator October 2017 – March 2019
Supported database operations and maintenance activities at the U.S. Patent and Trademark Office
Collaborated with application teams supporting implementation of Change Advisory Board approved scheduled service requests such as configuration changes, application release and deployment management, database security remediation and patching
Managed core tasks supporting customer applications such as database backups, recoveries, remediation of security vulnerabilities and database service operation and monitoring
Participated in proactive and reactive aspects of service incident, problem and event management. Contributed to resolving service errors in an effort to lower risk of service disruption
MSI Universal April 2017 – June 2018
Oracle DBA
Provided database administration of financial management applications supporting the Department of Commerce
Installed and configured Oracle 12c database software on Red Hat and Solaris in development, test and production environments
Performed 11g to 12c database upgrade and migration
Deployed database installations utilizing RDBMS home cloning in development, test and production environments
Partnered with security team to identify and remediate vulnerabilities discovered in periodic security scans
Configured transparent database encryption (TDE) utilizing Oracle 12c tablespace encryption
Deployed database recovery through network database duplication (cloning) utilizing recovery manager (RMAN) across development, test and production environments
Provided support to application teams to refresh lower database environments from production utilizing Data Pump and RMAN
Installed and configured Oracle 12.1 OEM on Red Hat Linux
Administered consolidated 12.1 and 12.2 databases within OEM and utilizing SSH to database servers
Configured RMAN database backup utilizing Oracle 12c OEM
Continually provided support to O&M database activities, including database backup, recovery, database resource allocation and alert management.
Collaborated with application and data center teams on disaster recovery exercises
Communicated with database, application, security, and customer teams supporting financial management applications to the Department of Commerce and continually provided database support
Provided database support during maintenance activities. Applied quarterly database security bundles, patch set updates in development, test and production environments
TekSystems / College Board December 2015 – March 2017
Consultant / Database Administrator
Performed Oracle database installations, upgrades and patching following internal and vendor support documentation
Configured, upgraded and patched Oracle Grid, Real Application Clusters (RAC) and stand-alone database installations. Tested and provided troubleshooting database performance and network bottlenecks
Monitored database log shipping to remote Data Guard database installations and verified successful synchronization of database Disaster Recovery sites
Utilized PL/SQL built-in packages to troubleshoot database and query performance issues
Advised customers and end-users in regard to query or application code improvements and implementing query or database performance tuning
Participated in scheduled maintenance activities, including application code deployments and database migrations
Performed database health checks and communicating status accordingly
Continually collaborated with database and application teams on implementing database fixes as part of Release Management activities
Supported database application users with locked or expired database accounts, problematic database queries or sessions and timely communicating resolution status
Verizon January 2005 – September 2015
DBA
Worked with TAM and PMO teams on server build implementations. Installed Oracle 9i/10g/11g on Windows and LINUX platforms
Installed and configured Oracle RAC and CRS software. Created, administered and provided tuning of High Availability clustered Data Guard database sites
Managed and supported Weblogic instances supporting Oracle database. Performed Weblogic maintenance, patching and overall support on an ongoing basis
Created standby databases, cloned databases, refreshed schemas and databases; provided full database Data Pump dumps and schema or table level dumps to DEV/QA database environments
Delivered support in quality assurance of the application delivery, code releases, and patching in the production and UT environments
Consistently monitored and resolved issues related to database resource allocation via OS command-line tools or Oracle Grid Control / Enterprise Manager (OEM)
Backed-up and recovered databases using RMAN. Modified backup scripts according to standard operating procedures, validated backups and database restores
Participated in application code deployments and performed data migrations
Performed database upgrade and applied Oracle security patches
Provided maintenance of Oracle RAC databases, Data Guard, CRS and ASM
Participated in tuning the DB and OS level (database sessions with high CPU and memory)
Provided maintenance of SQL Server 2008 / 2012 scheduled jobs, monitored disk space usage, resized data files and transaction logs
Responded to database monitoring tickets. Analyzed, researched database errors, performed availability and performance troubleshooting and continually communicated resolution status to team members, customers and business process owner
Training and Certifications:
Oracle Cloud Infrastructure & Database Administration 2019
SQL Server 2008: SQL Server for Non-SQL Administrators 2013
Maintaining Microsoft SQL Server 2008 R2 Database 2011
Oracle 11g OCP 2011
ITIL V3 Foundations Certification 2010
Oracle 11G RAC 2009
Oracle 10G RAC 2008
Citizenship: US Citizen
Contact this candidate