Sql Server Human Resources

OBJECTIVE

An accomplished database administrator with demonstrated success in

managing and supporting databases in a multi environment/platform

infrastructure that require by high standard healthcare industry. Proven

ability to analyze, architect, design, implement and deliver technology

that decrease cost, increase performance, security, and positively affect

the business in its all aspects.

SUMMARY

Qualifications Highlights

. Deep understanding of information technology with focused on nonstop

delivery databases services with having in mind the main business

expectations such as high availability, integrity, performance and

above the all security of data and databases.

. Extensive experiences working with all aspect of in-house diverse

development system.

. Design and development a cost effective high quality database

management system while maintaining the constant growth of the demand.

. Believe in team working, mentoring, problem solving in order to

maintain high quality performance and attitude within infrastructure

team

TECHNICAL SKILLS

Programming Languages

Transact-SQL, SQL Plus, Standard SQL, PL SQL, Java, Perl, Visual Basic,

C#, Linux shell scripting, Windows shell scripting

Software

Oracle Enterprise Manager, SQL Server Enterprise,Embarcadero Rapid SQL,

SQL Plus, Oracle Discoverer, TODD, Microsoft SQL Query Analyzer, Microsoft

Excel 97-2007 and, Microsoft Access 97-2007, BiQuery by Hummingbird,

ReportSmith 3.0 by MBH Solutions, Microsoft Visio 2003, Microsoft Office 97-

2007, Microsoft Outlook 97-2007, Microsoft Project 97-2003, Adobe Photoshop

6.0. Microsoft .Net environment, ERwin data modeling tool

Servers and Systems

Oracle database 11g,Oracle database 10gR2, Oracle database 9i,

Microsoft SQL Server 7.0-2008, Windows XP Professional, Windows 2000-

2008, Active Directory, Tivoli Back up server(TSM), Oracle Recovery

management (RMAN), Linux ( Redhat Enterprise), Windows Cluster

environment, Oracle RAC environment, MySQL

EXPERIENCE

Cascade Healthcare Bend, OR

02/07 - present

Database Administrator III/Team Lead

Perform database administration tasks over 350 databases hosted by 45

servers, in Oracle(9i - 11g), MS SQL (2000 - 2008) and MySQL environment

include but not limited to

. Data modeling, database design, development, implement and maintenance

for in-hose applications and reporting purposes.

. Improving and maintaining database performance by tuning, optimizing,

and evaluating daily utilization.

. Performing backup and recovery databases processes by using utility

tool and media such as Oracle RMAN and Tivoli Storage Manager. This

process should support the business SLA which data recovery with less

than 45 min data loss.

. Develop intense security protocol to protect patient data. The

process should support business and application requirement while it

grantee data security.

. Assist application analyst/developer in process of establishing a

target data and database architecture to enable business and end users

to capitalize on their data assets.

. Work with the Applications and Reporting groups to facilitate data

storage and retrieval strategies and participates in cross functional

groups to develop data driven business solutions. This could hands on

programming processes to develop utilities such as store procedure,

DTS packages, ETL process and even developing reporting utilities.

. Work to ensure data quality and integrity throughout the data

lifecycle.

. Built and configure stand-alone and cluster servers to increase and

insure the high availability, accessibility, and scale ability of

databases services in a 24/7 healthcare environment.

. Advice and architect database production system from production to

disaster recovery process and provisions.

. Assuring all above process and services align with the industry's best

practices as long to support business' priorities and commitments.

Central Oregon Community College Bend, OR

1/2010- present

Part time Instructor

I have recently joined to Central Oregon Community College to transfer some

of my technical and industrial experiences to those students who will be

the backbone of the industry in years to come. My goal will be achieved, if

I can teach my students to "learn how to learn

Magellan Health Services Dallas, TX

7/04 - 03/07

Sr. Information Analyst - Programmer/Team Lead

This role was responsible for development and implement advanced level data

study designs/ data mining, QIAs and analytics' protocols, coordinates data

collection processes, conducts complex data analysis, and prepares reports

for outcomes management and quality improvement projects for Clinical and

Claim groups. This position was directly supervised by VP of quality and

indirectly cooperates with the corporate database and analytical

department. The other professional factions and responsibilities in this

role were:

. Coordinate/manage advanced level projects including meetings with

personnel at local and national departments in order to perform

necessary functions related to developing or modifying survey

instruments, conducting quality and outcome studies, developing and

maintaining databases, analyzing findings and reporting results.

. Develop protocols for sampling, data collection, statistical analysis,

data mining and reporting.

. Develop and maintain databases and SQL scripts for analysis of

findings, including the development of project specific applications.

. Perform advanced level database management such as create stored

procedures, views, tables, DTS packages in SQL server and data

modeling/ETL in data warehouse Oracle database environment.

. Train staff on protocols and data collection instruments.

. Develop query and scripts to customize the local reports to meet the

senior management requirement and reduce the dependency on the

corporate data management office.

. Develop several tools for internal clients to trace down and manage

their activities on regular bases.

. Convert several existing reports to comply with new environment

(Access to MS SQL, or Oracle Data warehouse).

. Close work with the team that transited million records of data from

MS SQL server environment to Oracle 10g.

. Close work with team in defining and building Discoverer data mart in

Oracle 10g database.

. Managing small to medium IT project ( database and application

development projects)

Bowne & Co., Inc. - Bowne Financial Printing

Dallas, TX 6/03 - 7/04

Human Resources Information System (HRIS) Specialist / Data Analyst

. Responsible for developing reports, generating statistics, and

ensuring the integrity of the data for the following Human Resource

departments: Accounting, Administration, Human Resources, and Payroll

. In charge of communicating with Senior Managers to ensure the

accuracy and adequacy of the human resources information

. Responsible for troubleshooting and investigating solutions for

different types of data manipulation processes. Retrieve query and

data analysis using the BI Query reporting software. Maintain a

working database by creating profiles, maintaining shift tables and

employee tables for the internal database. Maintain HRIS local

database in MS Access.

. Contribute to centralize and maintained the time and attendance

database for more than 1,900 employees.

. Meticulously, maintained data processing and report inquiries for HRIS

and Payroll department on day-to-day business. These departments used

the reports to process benefits and payment information for 2,500

employees.

. Designed and developed Access database for the HRIS department that

allowed coworkers to quickly enter information, retrieve data, and

prepare reports in 17 remote sites. This database enhanced the

integrity and proper tracking of all data received by the HRIS

department.

Bowne & Co., Inc. - Bowne Financial Printing

Dallas, TX 4/98 - 6/03

Senior System Specialist

Servers and networks configuration as well as maintained network

reliability, security, and availability. Supported and maintained the

security of multiple networks with over 500 hundred Windows NT / 2000 user

accounts. Performed LAN and wireless networking setup and configuration for

250 employees. Routinely performed hardware maintenance, upgrades, and

component-level troubleshooting on workstations and servers. Set up and

configured various operating systems from Windows XP - 2000. Set up and

configured SQL server applications on Widows 2000 servers.

. Designed and upgraded a security monitoring application that aided

managers and receptionists in monitoring employee traffic in five

major sites.

. Contributed to a team in upgrading network infrastructure that

increased network availability, scalability, and reliability by 100%

. Supported more than 400 employees in both local and remote sites for

five years

. Developed and designed several web-based applications using the .NET

environment with SQL server as the database backbone.

. Designed and developed modules and stored procedures in SQL database

for various two and three tier client / server applications.

TECHNICAL TRAINING

Microsoft Windows NT 4.0 Administration

Microsoft Window 2000 Administration

ASP and ADO Programming in .NET Framework, Microsoft SQL Server 2000,

Microsoft Project 2000, Microsoft Access 2000

EDUCATION

University of Phoenix; Phoenix, Arizona

Master of Science in Computer Information Systems; 2004

University of Texas; Arlington, Texas

Bachelor of Science in Computer Science and Engineering; 2001

Middle East Technical University; Ankara, Turkey

Bachelor of Science in Petroleum Engineering; 1992

Miscellaneous

. US Citizen.

. Fluent in English, Farci, and Turkish Languages.

. Willing to Travel.

Contact this candidate