Sql Server Developer

AYTEKIN ERIS

416-***-**** *******.****@*****.***

SUMMARY

• Over twenty years of extensive experience in IT.

• Twenty years of solid Database Design/Development/Administration experience on MS SQL 2000/2005/2008 Server, Oracle 10g/11g and Sybase 12.x/15.x on Windows NT/2000/2003/2008 and Unix/Linux platforms in distributed environments (Sybase Clustered Edition/Replication, SQL Server Cluster/Replication).

• Experienced in Shell programming on Unix and Linux.

• Strong knowledge of programming with MS Visual Foxpro, Cobol, C.

• Windows XP and Windows NT/2000/2003/2008 experience.

ACCOMPLISHMENTS

• Completed 50 million $ securitization project with Bear Stearns in Garanti Leasing.

• Moved software and infrastructure from Digital VMS to Windows and HP-UX, including Ingres to Sybase, Multiplan to Excel, All-in-One to Exchange and Word in Garanti Leasing.

• Converted DOS based insurance software to Visual FoxPro for Oracle 9 on Unix at Hur Insurance.

• Coordinated web development for online realtime stock trading in Inter Investment. Developed online web content management software.

• Migrated/converted SQL 2005 databases to redesigned Sybase 15 databases on Redhat Linux in Questrade.

PROFESSIONAL EXPERIENCE

Questrade, Toronto, Canada, October 2009 to January 2012

Database Developer

• Database logical/physical design.

• Stored procedure/trigger/function development for Sybase and SQL Server.

• Performance tuning.

• Migration/conversion of company's databases from SQL 2005 on Windows to newly designed Sybase 15 databases on Linux.

• Respond to and resolve database problems and performance issues.

• Analyze performance/storage issues, provide improvement ideas to system/development teams.

• Help developers to create new or redesign existing table/database structure, data search/retrieval strategies and methods.

• Review submitted database changes and code.

• Assist QA team in their data related investigations.

• Respond to and resolve database problems and performance issues.

• Build database schema, tables, procedures and permissions.

• Analyze, consolidate and tune database for optimal efficiency.

• Design logical data models and transform into physical database structure using Sybase PowerDesigner.

• Work with QA during test and deployment.

• Perform DB administration tasks related to development, i.e. database refresh, SQL Server/Sybase installation, server configuration changes.

• Review database scripts for adherence to standards and policies.

• Communicate with developers in their development process.

• Provide database technical support, deployment and configuration/development standards.

• Analyze, consolidate and tune database for optimal efficiency.

SKILLS USED: Sybase, SQL Server, C Programming, Windows Scripting, T-SQL, SSIS, Shell Scripting, DB Design, Performance Tuning, C Programming

Teranet, Toronto, Canada

Sr. DBA for Oracle/MS SQL Server/Sybase, July 2008 to November 2009

• Installing, administering, upgrading, configuring and troubleshooting Oracle 10g/11g, SQL Server 2000/2005 and Sybase 15.

• Fulfilling requirements from tickets and change request tasks.

• Performance tuning.

• Preparing documents.

• Carrying DBA on-call pager.

SKILLS USED: SQL Server, Sybase, Oracle, T-SQL, PLSQL, Shell Scripting, Windows Scripting, Performance Tuning

University Health Network, Toronto, Canada

Sr. Sybase/MS SQL Server DBA/Developer, Jan 2006 to July 2008

• Installing, administering, configuring and troubleshooting SQL Server 2000/2005 and Sybase 12/12.5 problems.

• Performance tuning for Sybase Server as well as applications.

• Maintenance activities like reindexing, defragmentation, database expansion and error-log checking.

• Installed 64-bit Sybase 12.5 and completed migration and upgrade of 60 Gb finance database from 32-bit Sybase 12/32-bit AIX to 64-bit Sybase/64-bit AIX for production/development and test servers.

• Provides support for database loading and/or conversions.

• Develops shell/sql scripts and stored procedure for database administration purposes.

• Installs/configures auditing and retrieves relevant data for reporting.

• Perform backup/restore and disaster recovery procedures.

• Prepare and implement MS SQL Server and Sybase software upgrades, migrations and patches.

• Perform monitoring activities.

• Database design and server tuning.

• Stored procedure/trigger development, modification and fine tuning.

• Provides DBA support to development/implementation projects and

• Performs storage planning and tracking.

• Provides DBA on-call pager support.

SKILLS USED: SQL Server, Sybase, T-SQL, Windows Scripting, Shell Scripting, Performance Tuning, SSIS

Medisolve/Pristine Printing, Toronto, Canada

System/DB Administrator, July 2005 to Dec 2005

• Installing, administering, configuring and troubleshooting Windows and Linux servers.

• Providing end user support for Windows XP/2K Professional.

• Administering MySQL and MS SQL Server 2000 databases.

• Developed software with MS Visual Foxpro 9 for the kiosks running XP Pro and W2K Pro.

Inter Investment, Istanbul, Turkey

Sr. SQL Server DBA/Developer, Oct 2002 to June 2004

• Participated development team implementing commercial web site with MS SQL Server 2000, ASP, XML and HTML on MS W2K and IIS 5.

• Finished development of real-time web content management and internal auditing programs, which produces needed formatted Excel reports using OLE objects, with MS Visual Foxpro and MS SQL Server 2000 in client/server architecture.

• Developed module for distribution of daily report to subscribers who are recorded in the database, in html format as links and/or as pdf attachments.

• Performed data and system security operations.

• Performed installation, configuration and maintenance of SQL Server Database.

• Contributed to the development of an efficient, effective organization that uses defined processes, standards, and procedures; primarily on security, SQL development, system administration.

• Administered two MS SQL Server and one Oracle 8 databases and developed SQL scripts/stored procedures.

• Responsibilities included physical and logical design, performance tuning, troubleshooting, storage planning, database file distribution, table creation, view creation, back up and restore.

Hur Insurance, Istanbul, Turkey

Oracle DBA/Developer, July 2000 to Sept 2002

• Developed, maintained and converted insurance software with Visual Foxpro and Oracle 8 on NCR/SCO Unix.

• Administered, well-tuned and troubleshooted Oracle 8 database.

• Wrote stored procedures with PL/SQL.

• Administered NCR/SCO Unix.

Garanti Leasing, Istanbul, Turkey

Sybase DBA/System Administrator, April 1994 to June 2000

• Installed, configured, maintained 150 user NT/Unix network with Sybase Adaptive Server Enterprise 11, Exchange 5.5, IIS 5.0 on HP and IBM servers.

• Supported and administered Sybase Server 11.

• Analyzed problems and developed solutions to meet corporate needs.

• Administered VAX VMS OS and INGRES RDBMS.

• Planned and led migration/conversion of Ingres database on VAX VMS to Sybase on HP Unix.

• Developed periodical reports for management both on Sybase and Ingres.

Integra, Former Distributor for Sybase, Istanbul, Turkey

Sybase DBA/Developer, July 1991 to March 1994

• Provided pre and post sale Sybase support for installation, tuning and development.

• Conducted training for customers.

Koc-System, Former Distributor for Unisys, Istanbul, Turkey

Unix & Desktop System Supporter, March 1989 to June 1991

• Provided support to customers for Unix and DOS.

• Installed, configured and tuned Unisys Unix.

• Did installation, performance tuning, customization and maintenance for Oracle 5/6, RM Cobol/MF Cobol.

• Conducted Unix, DOS, SQL, Cobol, C, Pro*Cobol, Pro*C and Oracle training.

• Wrote Unix shell and AWK scripts.

CERTIFICATES

• Microsoft Certified Application Developer for C#.NET, 2005

• Microsoft Certified Database Administrator, 2006

• ITIL (Information Technology Infrastructure Library) Certificate, 2006

• MCITP: Database Administrator/Developer SQL Server 2005, 2007

• ITIL (Information Technology Infrastructure Library) V3 Certificate, 2008

EDUCATION

• BA in Economics, Faculty of Administrative Sciences, Bogazici University, 1985, Istanbul

• BS in Mathematics, Faculty of Arts and Sciences, transferred to Economics after 2 years, Bogazici University, 1982, Istanbul

• English Preparatory School, Faculty of Education, Bogazici University, 1979, Istanbul

SKILLS

• Databases : MS SQL Server 2000/2005/2008, Sybase 12/12.5/15, Oracle 6/8i/10g

• Programming Languages : MS Visual Foxpro 7/8, C, Cobol, C#.NET, Bourne/Korn Shell, AWK

• Operating Systems : MS Windows 2K/2K3/2K8/NT/XP/Win7, Unix, Linux

• 4th Generation Languages : SQL, MS SQL Server T-SQL, Sybase Transact SQL

• Other : Remedy, DBArtisan, Enterprise Manager, Management Studio, Sybase Central, SQL Advantage, PowerDesigner

COURSES

• SL110 Java Programming Language, 1999

• SL276 Java Programming Language, 1999

• Coaching Approach in Management, 1998

• Sybase System11 Fast Track to SQL Server, 1997

• Sybase Physical Database Design , 1997

• Sybase System & Database Administration, 1997

• Introduction to PowerBuilder, 1997

• Specializing in Data Windows, 1997

• Advanced Data Window Technologies, 1997

• Performance Management with PowerBuilder, 1997

• TCP/IP, 1997

• Administering MS Windows NT 4.0, 1997

• Time Management, 1996

• Oracle Advanced Application Building, 1990

• Introduction to Oracle, 1989

Contact this candidate