Ismail Guzey
Fort Worth, TX US Citizen
Phone: 309-***-**** ******@*******.*** www.linkedin.com/in/ismail-guzey-2490023
CURRENT OBJECTIVE
Seeking for a database engineer/architect position, where I could apply my extensive experience and knowledge, while keeping up with new data management technologies.
EXPERIENCE
Senior Database Administrator Team Lead (Cloud Services) Stamps.com, 3/2012 –current Los Angeles, California, USA
Stamps.com is the leading provider of Internet-based mailing and shipping solutions.
As a Database Team Lead, I am responsible for working primarily with development and operations teams to help Stamps.com stakeholders grow the business.
Engineered and managed an enterprise-wide migration of SQL databases to AWS, with minimum downtime to the databases, jobs, replication, etc.
Implemented Always On Availability Groups in AWS, enabling high availability and disaster recovery for critical database workloads.
Configured EC2 servers with appropriate instance types, EBS volumes and IOPS to achieve good cost-performance balance.
Optimized processes, stored procedures, SSIS packages to improve performance.
Created documentation for maintenance and orientation procedures, uplifting the team's competencies and ensuring a seamless knowledge transfer.
Database Administrator Tagged.com, 1/2012 –3/2012 San Francisco, California, USA
Tagged.com has acquired another social media company, Hi5.com. I worked on a project to migrate the Hi5 data (~5TB), that resided in SQL Server 2008 R2 database servers (60 servers) to Oracle 10G servers . Also participated in production support for the SQL servers.
Database Administrator St. Joseph Healthcare, 7/2010 –9/2011 Anaheim, California, USA
• Created SSIS packages and staging databases, to use data from these sources instead of linked servers and reduced the running time significantly for the nightly running processes.
• Optimized stored procedures and SQL code to reduce running times of jobs and reports
Database Engineer Molina Healthcare, 1/2008 –2/2010 Long Beach, California, USA
Designed and implemented a solution that will restore production copy of the databases to test servers automatically with an option to use LightSpeed, SQL jobs, stakeholders, mount points, keeping the existing users, roles and permissions that saved lots of dba hours.
Designed and implemented a job scheduler system, which will kick start jobs when the resources specific to that job are not exhausted, thus preventing job failures and performance problems during the night.
Optimized nightly running processes and procedures to reduce the time and resources they took from the system and saved 1st and 2nd level work hours.
Worked with 1st level management to select which SCOM alerts to go to which level of dba team, found solutions to prevent false alert generation, reduced the number of tickets from hundreds to tens a day and saved work hours that were wasted to close these tickets.
Leaded a project for migration of the databases from SQL2000 to SQL2005.
Database Administrator
State Farm/Ciber
10/2005 – 1/2008
Database Engineer/Architect
Verizon/Tata Consulting
9/2004 – 10/2005
EDUCATION
M.S. in Computer Science, Maharishi International University, Fairfield, Iowa
B.S. in Electrical Engineering, Yıldız University, Istanbul, Turkey
SKILLS
15+ years’ experience in database administration; on call support, backup, security, performance, failover management and disaster recovery.
15+ years’ experience in database development; including implementation, logical and physical database designs, SQL DML, DDL and ETL (SSIS), Replication.
15+ years’ experience in software development life cycle, programming languages, scripting.
15+ years’ experience in quality management standards; ISO 9001, SOX, PCI.
15+ years’ experience in working with operating systems.
Languages
VB.NET, Visual Basic, Visual FoxPro, VB Script, JavaScript, C#, Powershell
Databases and Components
SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019 Oracle 7-9, FoxPro, Reporting Services, Integration Services, Analysis Services (SSRS, SSIS, SSAS),Aurora Mysql
Tools
Power Designer, Erwin, ER Studio, Ms Visio, Rational Rose, Quest Litespeed, Quest Performance, SQL Sentry, Redgate SQL Compare and Data Compare
Platforms
Windows 9x-2019, Active Directory
IDE’s
Microsoft Visual Studio .Net, MS Visual InterDev, Business Intelligence Development Studio.
Reporting Tools
Crystal Reports, Visual FoxPro, MS Excel, Ms DataReport, MS Reporting Services
Others
Visual SourceSafe, Altiris, Scom, HP Open View, Lotus, Jira, Confluence, Notes, Fogbugz, Perforce, Swarm, Github, Octopus, Nagios
OTHER
MCTS SQL 2008 DEV
Microsoft Certified Technology Specialist
2010
MCTS SQL 2008 BI
Microsoft Certified Technology Specialist
2009
MCITP SQL 2005
Microsoft Certified IT Professional
2007
MCAD .NET
Microsoft Certified Application Developer
2006
MCTS SQL 2005
Microsoft Certified Technology Specialist
2006
MCDBA
Microsoft Certified DBA
2003
OCA
Oracle Certified Associate
2003
MCSE
Microsoft Certified Systems Engineer
2000
MCP
Microsoft Certified Professional
1998