SOFIA NIKEDIMOS

571-***-**** /adrpoe@r.postjobfree.com

DATABASE ADMINISTRATOR WORK AUTHORIZATION-US CITIZEN

Database Administrator with extensive experience in database design, monitoring & tuning, security implementation and risk analysis, as well as backups and recovery on Windows, and Linux.

I am a highly motivated SQL server Database Administrator with 5 years of experience in Database Administration. Team player, highly detail oriented, well organized, with strong analytical and problem-solving skills. Prioritize assigned tasks and ensure they are completed on or before the completion date, with an excellent customer service orientation. Proficient in an assortment of technologies, including Oracle, MS SQL Server.

DBA skills include:

Expertise Performance Tuning & Capacity Monitoring

Enriched experience in Backup & Recovery

Expertise in Standby/Failover Administration

Enriched experience in SQL Tuning in an Oracle Environment

Well versed in Data, Database and System Security

Proficient in Patching, Upgrading, Migration & Cloning

Enriched experience in SQL Tuning for Performance Optimization

Well versed in Database & System documentation

Flexible and versatile to adapt to any new environment and dedicated to update technological skills.

Excellent in performance tuning, troubleshooting and query optimization using native tools like Activity Monitor, Perfmon Counter, Dynamic Management Views (DMV), Extended Event and Profiler.

Enriched working experience in physical and virtual, stand alone and highly available systems.

Support proactive system monitoring and alerting to include disk backup management, compliance in security and configuration control.

Experienced in automated recurring or redundant database tasks as maintenance jobs to run from SQL Server Job Agent or task scheduler.

Proactive and can work both independently and collaboratively with staff, internal and customers.

Efficient in working multiple projects with multiple deliverables.

Ability to meet deadlines and produce effective results, while working both independently and in teams with a strong ethics in following business requirements.

Excellent communication with multifunctional teams, programmers and technical staff at all levels.

PROFESSIONAL EXPERIENCE

Client: Bereans Information Technology, Washington, D.C. 02/2021 – Present

Role: Database Administrator

Installed, configured, maintained, upgraded, and patched database servers SQL Server 2012, 2014, 2016 and 2017 in line with company’s optimization and security policy.

Successfully upgraded database servers from SQL Server 2008/2008R2 to 2012 and from SQL Server 2012 to 2014/2016/2017.

Worked in converting physical SQL servers to VM ware servers.

Implemented appropriate backup and restore strategies to protect all data assets.

Ensured that production databases are running efficiently by Monitoring database performance.

Worked in configuring HADR solutions like replication, database mirroring, and log shipping.

Monitoring and Tuning including capacity planning and report creation / distribution

Database patching and upgrading

Cloning using utilities and manual methods for all database sizes

Database security policy creation and institution, as well as reporting (i.e. fine grained auditing, data encryption, backup encryption, network security, system security)

Troubleshoot and resolve database integrity, performance, blocking and deadlocking issues.

Institution of backup strategy and policy; Implementation of backup schedule for both logical and physical backups

Institution of recovery strategy in disaster scenarios; Institution and implementation of standby / failover systems in disaster scenario ● Work on On Call DBA rotation.

Database documentation during project planning, project execution and project maintenance phases

System Documentation - typically a required deliverable after a client’s database design and implementation with documentation generators or tools such as SQL Developer, Dataedo.

Client: Ford Credit – Franklin, TN 03/2016-01/2021

Role: SQL Server DBA

Responsibilities:

Installation and Maintenance of SQL Server 2017/2016/ 2014/2012/2008 R2/2008 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.

Supported 24 X 7 Production environments and solved incident Tickets.

Set up Always on Availability Groups as a high availability for group of databases in SQL 2017/2016/2014/2012 instance.

Implemented in-memory OLTP feature in SQL Server 2014/2016.

Migrated SQL server 2008/2008R2 to SQL Server 2012/ 2014/2016/2017 and also physical to virtual environment.

Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.

Performance monitoring of server by windows performance monitor and SQL Profiler and fine-tuning of databases for its performance using Database Tuning Advisor and used Index Tuning Wizard to redesign and rebuild the indexes for better performance.

Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Assisted in production OLAP cubes, wrote T-SQL queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Migrated databases from physical and Virtual instance to Microsoft Azure cloud.

Configured on-premises Sql database backups to Azure using Microsoft Azure Backup tool.

Creating logins, users and assigning the permissions to the users in Azure.

Configured Active Geo Replication, Failover Groups using Azure portal.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Used Joins and sub-queries in T-SQL for complex queries involving multiple tables from different databases

Migrated several on-prem SQL Servers to AZURE with complex topologies, such as Always ON, database mirroring, log shipping and replication that reduced management overhead and efficiently deliver highly resilient services.

Installed SQL Server 2014/2016/2017 (Silent and Traditional) in HA/DR environments.

Setting up Always On/ database mirroring and log shipping to ensure continuous data availability and to avoid downtime.

Used DB monitoring tools, such as Idera SQL diagnostic manager to identify and solve database issues that impacted application performance, health, or availability problems within SQLServer environments

Oversaw ITIL process, involving change management, incident management, and problem management for delivering efficient IT support services.

Responsible for managing Offshore SQL servers and offshore resources.

Involved in monitoring the backup jobs and fixed the failed jobs.

Managed cubes processing for production OLAP servers.

Involved in creating ETL Flows and SSIS packages.

EDUCATION & TRAINING

BSc in Economics and management

Oracle Database 12c Administrator Certified Associate

CompTIA A+ Certified

Contact this candidate