Ilker Akyil Mcse-Data Management And Analytics Email & Phone Number

Durham, Nc

• Install, deploy, monitor, maintain, and performance tune Measurement Incorporated’s databases while ensuring high levels of data availability. • Ensure that users can access the data concurrently in a form that suits their needs and that there are appropriate provisions for data security and recovery. • Monitor system capacity for existing requirements and help ensure plans are in place for future needs. • Responsible for assisting in the development and implementation of database policies and procedures ensure the integrity and availability of databases and their accompanying software.• Developed DBA’s Corner Web application combined with SSIS, SSRS and SQL Jobs to monitor SQL jobs/backups/databases/users/instances• Installed/Configured Idera Diagnostics Manager and SQL Doctor• Involved in installation and configuration of MS SQL Server 2008/2012/2017 clusters• Setup TDE enabled databases with replication

• Involved in installation and configuration of MS SQL Server 2005/2008• Created SQL Server monitors/alerts/rules using Microsoft System Center Operations Manager (SCOM). Proactively monitored the database systems to ensure secure services with minimum downtime• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.• Detected and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.• Troubleshoot and resolved database integrity issues, performance issues, blocking and deadlocking issues• Installed/Configured Idera Diagnostics Manager, Idera Compliance Manager and SQL Doctor• Created/Modified SQL Server Intergration Services Packages• Prepared Visio diagram for company database servers with detailed information• Performed daily, weekly, and monthly data maintenance tasks• Managed security by defining roles and rights.

• Supported Hardware/Software, ghost images, PC & phone deployment of 300 users• Setup virtual servers on MS Virtual Server 2005 and Hyper–V and virtualized 20+ servers• Implemented DNS, DHCP, Active Directory, Terminal Services, Group Policy, Print Servers, File Sharing• Developed laptop assignment tracking system, solution center based intranet sites, Microsoft select CD request website, tracking, automatic emailing functions using ASP/VBScript on SQL Server 2000• Managed project upgrading phone system from Nortel Systems to Cisco VoIP• Provided ongoing setup and support of VoIP Phones including user accounts, voice mailboxes on Cisco Call Manager 4.0 and 6.1 including Attendant console support• Setup daily backup jobs on HP LTO2/LTO4 Autoloader, rotated and sent out tapes, restored data as needed• Worked diligently to exceed Help Desk SLAs and to meet project schedules.• Took ownership of the task and will work it to completion.

• Supervised 20 people on Pa1mOne phones reflash/production process• Created Pa1mOne LAN to manage reflash process and get log files• Coordinated with IT Department to configure computers• Prepared scripts to automated copy of scenario file to SD Cards• Created spreadsheets to check daily production rates• Prepared POS/Shipping Labels, setup barcode scanners

• Designed, maintained, updated company web site with ASP and Access Database/SQL• Designed website using HTML, JavaScript, ASP, Flash, Dreamweaver, Fireworks, Photoshop• Developed Online Ticket System (OTS) using ASP and VBScript• Managed, administrated LAN/WAN, opened email accounts on MS Exchange Server• Setup network group policy, domain user accounts on Windows Server Active Directory• Used Norton Ghost to fix/set up WAN, LAN computers• Daily backups, log files, create/maintain users, shared resources• Installed/configured Dell/ABC2000/Compaq/HP computers and components

Diploma, Website Design

Ms, Organic Chemistry

Activities and Societies: Photography Club