Gary Sjah

Email: ac8eag@r.postjobfree.com c: 419-***-****

Summary:

• 7+ years experience in database development and administration experience in MS SQL Server 2014, 2012, 2008R2, 2005 – installation and maintenance, backup/restore strategy and implementation, transactional replication creation and maintenance, security, mirroring, clustering, replication

• 7+ years experience in data modeling, database design, programming, and support.

• Experience in creating and maintaining clustered SQL Server instances

• Experience in creating and maintaining database SQL Server high availability (“Always On”), mirroring

• Experience in creating and maintaining linked servers between two SQL Server instances

• Extensive experience in creating and maintaining database replication (transactional)

• Extensive experience in working with Transact-SQL for database programming.

• Extensive experience in designing of Databases in MS-SQLServer 20014, 2012, 2008R2, 2005, and Oracle.

• Extensive experience in designing Entity Relationship Diagrams.

• Extensive experience in writing complex Stored Procedures, User-Defined Functions (UDF), and Triggers.

• Tuned performance by creating/building/rebuilding indexes on appropriate fields, and by tweaking queries.

• Extensive experience in building SQL Server Reporting Service (SSRS) reports utilizing both Shared and Dedicated data sources, single and multiple data sets

• Experience in administering and troubleshooting of SQL Server Reporting Services (SSRS)

• Extensive experience in building SQL Server Integration Service (SSIS) packages to import/export data using BIDS.

• Experience in SSIS, DTS Import/Export Wizard, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, and SQL Query Analyzer, Access 2000/2003, Excel 2000/2003

• Excellent communication, interpersonal skills, and a team player.

• Extensive experience in Analysis, Design, Coding and Testing (Whole Life Cycle) of projects

• Strong analytical, logical and problem solving skills.

• Development skills with core competencies in:

o Database: MS-SQL Server 2014, 2012, 2008R2, 2005, ODBC, and ADO database connectivity and library, DTS, Stored Procedure.

o Database Clients & Tools: MS- SQL Management Studio, MS-BIDS, Argent SQL Monitoring, SQL Sentry, SQL Compliance Manager, Dell/Quest LiteSpeed, MS-SCOM for SQL. o Languages: SQL, Transact-SQL

o Methodologies: Solutions Development Life Cycle, Data Modeling, and Project Management.

Certifications: MCITP-DBA SQL Server 2008, ITIL Foundation Version 3 Education:

MBA – University Of Hartford, CT

B.Sc. – Oklahoma State University, OK

E-Commerce Solutions Developer Diploma – The Institute For Computer Studies, ON Software/Hardware:

SQL, Transact-SQL, VBScript, JavaScript, .Net Framework, MS SQL Server 2008/2005/2000, Microsoft Visual Studio.Net, Microsoft Visual Interdev, ADO.NET, Active Server Pages (Classic ASP), Active X, ADO, RDO, DAO, OLEDB, ODBC, MS Visio, HTML, DHTML, XML, Internet Information Server (IIS), MS-ACESS, SQL Server Management Studio/Enterprise Manager, Business Intelligence Development Studio (BIDS), 2

SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), SQL Server Agent, Windows NT Server, MS-BIDS, Argent SQL Monitoring, SQL Sentry, Idera SQL Compliance Manager, Dell/Quest LiteSpeed, MS-SCOM for SQL

Experience:

Karapoto Financial Technology (remote/telecommute) Sep 2017 - Nov 2018 Lead Database Analyst/Developer

Responsibilities:

• Designed and wrote complex/nested stored procedures for use in SQL Server Reporting Services

(SSRS)

• Installed, maintained, and supported SQL Server 2012/2014 in Development, Test/QA, and Production environments

• Created SQL Server 2012 Failover Cluster Instances

• Created Always-On SQL Server 2012/2014 instances on Win 2012R2 server

• Created and maintained transactional database replications

• Created and maintained database mirroring

• Created and maintained Service Principal Names (SPNs) for Kerberos Authentication usage between SQL Server instances

• Regularly performed SQL Server cluster failovers as part of both disaster recovery tests and regular maintenance

• Directed and supervised DBA team members to deploy Olla Hallengren's T-SQL scripts for regular database maintenance via SQL Agent jobs

• Deployed SQL Server Integration Service (SSIS) Packages

• Installed, maintained, and supported SQL Server Reporting Services (SSRS)

• Managed user access/permissions on the SQL Server instance and/or databases

• Managed Active Directory logins service accounts' access/permissions on the SQL Server instance and/or databases

Environment:

Microsoft® SQL ServerTM 2014, 2012, 2008 R2/2008, 2005 on Windows 2012R2, 2008, 2003 Servers Enterprise Edition, SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Service(SSIS), Data Transformation Services (DTS), SQL Agent, .NET Framework, Windows Failover Cluster Servers, Microsoft Active Directory, Service Principal Names, Disaster Recovery, SQL Sentry First Solar Inc., Perrysburg, OH Oct 2008 – January 2017 Database Administrator

Responsibilities:

• Responsible for installation, maintenance, and support of SQL Server 20014, 2012, 2008R2/2008/2005, both stand-alone and failover clusters in Development, Test/QA, and Production environments

• Performed production changes/deployments

• Created SQL Server Failover Cluster Instances (2008/2008R2 on Win 2003/2008R2 server)

• Created Always-On SQL Server 2012/2014 instances on Win 2012R2 server

• Created and maintained transactional database replications

• Created and maintained database mirroring

• Created and maintained Service Principal Names (SPNs) for Kerberos Authentication usage between SQL Server instances

• Regularly performed SQL Server cluster failovers as part of both disaster recovery tests and regular maintenance

• Customized and deployed Olla Hallengren's T-SQL scripts for regular database maintenance via SQL Agent jobs

• Deployed SQL Server Integration Service (SSIS) Packages

• Responsible for installation, maintenance, and support of SQL Server Reporting Services (SSRS)

• Responsible for maintenance and support of SQL Server databases for MS-CRM application

• Responsible for maintenance and support of SQL Server databases for MES, BPC, BizTalk, and BMC-Remedy, and various other applications

• Managed user access/permissions on the SQL Server instance and/or databases

• Managed Active Directory logins service accounts' access/permissions on the SQL Server instance and/or databases

• Extensive experience in Argent SQL Server Monitoring System

• Extensive experience in Dell/Quest LiteSpeed database backup file compression system

• Experience in Idera SQL Compliance Manager system

• Experience in using SQL Sentry for troubleshooting various database issues, and performance tuning

• ITIL-Certified

• Familiarity with BMC Remedy applications

Environment:

Microsoft® SQL ServerTM 2014, 2012, 2008 R2/2008, 2005 on Windows 2012R2, 2008, 2003 Servers Enterprise Edition, SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Service(SSIS), Data Transformation Services (DTS), SQL Agent, .NET Framework, Windows Failover Cluster Servers, BizTalk, BMC Remedy, SAP Basis, SAP IDM, Microsoft Active Directory, Service Principal Names, SharePoint, Maximo, MES, MES/PDR, HRIS, Kronos, EMC DataDomain, 3Par SAN, Microsoft SCOM, Argent, Disaster Recovery, SQL Sentry

JP Morgan Chase & Co., Columbus, OH Feb – Aug 2008 Database Developer – Production Support

Responsibilities:

• Responsible for data analysis/modeling, reverse-mapping, and database solution development of vendor billing system

• Monitored the progress of the project, attended business meetings and gathered new business requirements.

• Consistently met predetermined deadlines set for assigned tasks.

• Analyzed business requirements, designed and implemented Views, Stored Procedures and Triggers.

• Responsible for writing complex/nested stored procedures, both Table and Scalar-Valued User- Defined Functions (UDFs) for use in SQL Server Reporting Services (SSRS).

• Designed and automated DTS process using SQL Server Integration Service (SSIS) to extract data from external sources into development database.

• Created SQL Server Integration Service (SSIS) Packages for automated execution via SQL Server Agent Jobs Scheduling.

• Tested and debugged programs’ functionalities and codes.

• Responsible for extracting data as per business requirements.

• Responsible for importing and exporting data from/into various formats including CSV, XLS, etc. Environment:

Microsoft® SQL ServerTM 2005 & Windows 2003 ServerTM Enterprise Edition, XP, SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Service(SSIS), Data Transformation Services (DTS), SQL Server Agent, .NET Framework, Oracle, UNIX, TOAD, F-Secure Shell 4

Open Access Ltd., Toronto, ON Sep 2006 - Feb 2008

Database Developer/Administrator

Responsibilities:

• Responsible for data analysis/modeling and database development for Pension Plan Account Management system.

• Designed, developed, and documented highly structured, modularized, and scalable database applications adhering to SDLC best practices and standards.

• Ensured timely progress of the project, attended business meetings to gather business requirements.

• Analyzed, designed, and developed solutions to a wide range of business challenges.

• Implemented changes in mid-tier (ASP) modules to optimize query efficiency as well as application and database connection(s).

• Wrote complex/nested stored procedures, both Table and Scalar-Valued User-Defined Functions

(UDFs) generating tables and indexes.

• Established database mirroring (High Performance) between two SQL Server databases

• Created Database Mirroring Endpoints

• Provided periodic progress update to the Business side/project owners to ensure quality and timeliness of deliverables.

• Modified database design and mid-tier (ASP & JavaScript) modules to improve applications performance.

• Trained and directed junior developers in design and implementation of robust database applications.

• Assisted fellow developers in generating effective solution alternatives to address a wide range of business challenges

• Optimized database design through normalization/denormalization.

• Applied in-depth working knowledge of ODBC to troubleshoot various connectivity issues.

• Responsible for importing and exporting data from/into various formats including CSV/TSV, XLS, PDF.

• Demonstrated the ability to work on multiple projects simultaneously. Environment:

Microsoft® SQL ServerTM 2005/2000 & Windows 2003 ServerTM Enterprise Edition, XP, SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Service(SSIS), Data Transformation Services (DTS), SQL Server Agent, .NET Framework, ADO.Net, Classic ASP & VBScript, JavaScript, XML, Visual Studio .Net., Internet Information Services (IIS), FTP Server, WinFund, FileNet, Adobe Output Central JP Morgan Chase & Co., New York, NY Feb - Sep 2006 Database Developer/Administrator

Responsibilities:

• Responsible for data analysis/modeling and database design for intra-enterprise billing system.

• Monitored the progress of the project, attended business meetings and gathered new business requirements.

• Consistently met predetermined deadlines set for assigned tasks.

• Analyzed business requirements, designed and implemented Views, Stored Procedures and Triggers.

• Responsible for writing complex/nested stored procedures, both Table and Scalar-Valued User- Defined Functions (UDFs) generating tables and indexes for use in SQL Server Reporting Services

(SSRS).

• Designed and developed complex SSRS reports using Multi Valued Parameter (MVPs) and multiple DataSets.

• Created shared and dedicated (non-shared) DataSources for use in SSRS Reports.

• Designed and automated DTS process using SQL Server Integration Service (SSIS) to extract data from external sources into development database.

• Created SQL Server Integration Service (SSIS) Packages for automated execution via SQL Server Agent Jobs Scheduling.

• Tested and debugged programs’ functionalities and codes.

• Copied database structures and objects between development/UAT and production SQL Servers

• Established and maintained linked SQL Servers

• Verified structures and objects integrity in the linked SQL Servers

• Verified congruency between development/UAT and production SQL Servers

• Installed and configured FTP Server on development/UAT server.

• Created and maintained server and database logins/roles.

• Responsible for extracting data as per business requirements.

• Responsible for importing and exporting data from/into various formats including CSV, XLS, etc. Environment:

Microsoft® SQL ServerTM 2005 & Windows 2003 ServerTM Enterprise Edition, XP, SQL Server Management Studio (SSMS), SQL Server Reporting Service (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Service(SSIS), Data Transformation Services (DTS), SQL Server Agent, .NET Framework, ADO.Net, Classic ASP & VBScript, JavaScript, XML, Visual Studio .Net., Internet Information Services (IIS), FTP Server

Contact this candidate