SUMMARY:

• DBA/Developer for SQL Server 2014, 2012, SQL Server 2008/2008R2, SQL Server 2005, and SQL Server 2000 database servers.
• Administered databases for over ten years.
• Developed for databases using SQL for over 8 years.
• Have performed recoveries, mirroring, replication, clustering, performance tuning, capacity planning, and Server Side traces.
• Have written scripts for many different administrative tasks.
• Developed Database Web applications using SQL Server, MS Access, ASP, ASP.net, JSP, ADO, MySQL, PERL, CGI, and PHP;
• Collaborated with both end - users and IT personnel to gather project specifications; Broad spectrum of information technology experience.
• Trained in JAVA programming and Oracle administration and development.
• Over 10 years experience with database administration and development Trained in SQL Server 2008
• Experienced in performance tuning. Backups and restores, and disaster recoveries Experience with replication and mirroring and capacity planning Experience with database clustering on 2005 and 2008 servers Migrated SQL Server 2000 databases to 2005 and 2005 databases to 2008 Designed and created databases and database objects Written T-SQL scripts to implement mirroring, to start and stop replication and to monitor SQL Server performance Use DMVs to assess SQL Server performance Experience with SSIS, SSRS, and SSAS Experience with SQL Azure
• Experience with VMWare and Microsoft VM software Experience with multiple database engines Experience with Cognos Broad spectrum of information technology experience
• Developed full life-cycle applications Collaborated with both end-users and IT personnel to gather project specifications
• Converted and manipulated data from various formats into MS Access, SQL Server and MySQL Web enabled various database applications Supported both Internet and Intranet sites
• Developed Database Web applications using SQL Server, MS Access, ASP, ASP.net, JSP, ADOMySQL, PERL, CGI, XML, and PHP
• Ensured cross-browser compatibility with multiple Web applications Optimized Web applications and databases
• Designed and implemented databases in MS Access and FoxPro using Visual Basic that allowed for more effective inventory tracking, invoice tracking, and report and label generating Taught computer programs Windows 95, Word and Excel that increased employee productivity
• Have worked on a project to integrate email and postal mail data transfer with the Internet in order to more quickly deliver the data to management, facilitating management to make more timely and cost-effective decisions Six Sigma Yellow Belt qualified

TECHNICAL SKILLS:

ADMINISTRATIVE: Performance Tuning, Disaster Recovery, Capacity Planning, Backups and Restores, Replication, Mirroring, Clustering, Interpreting logs, Monitoring jobs

DEVELOPMENT: T-SQL scripts, Stored Procedures, SSIS packages, SSRS reports, cubes, dimensions, DTS packages, PL-SQL scripts

PLATFORMS: VAX, AS400, MS-DOS, PC-DOS, WINDOWS 3.1, WINDOWS '95, WINDOWS '98, WINDOWS NT, WINDOWS 2000, WINDOWS XP, WINDOWS 7, UNIX, LINUX Red Hat, Macintosh

SOFTWARE:

DATABASE: MS Access 2.0 - 2003, Filemaker Pro 4.0 & 5.0, Filemaker Server 5.0SQL Server 6.0 - 2012, MySQL, Paradox, Dbase, FoxPro, Oracle 8i, 10g

DATABASE TOOLS: SSIS, SSRS, SSAS, Idera, SQL Plus, Server Side tracingEMAIL - Eudora, Outlook, cc Mail

BROWSER: Netscape, Internet Explorer, Firefox, Opera, Chrome

OTHER: MS Office, WordPerfect, FTP, Visual Studio, Visual Studio .netFrontPage, Photoshop, Visio, IIS, APACHE, SourceSafe, VMWare, MS VM

LANGUAGES: T-SQL,SQL, PERL, CGI, Visual Basic, VB .net, ASP,ASP .net, PHP, Java, JSP, VBScript, JavaScript, VBA, CICS, COBOL, PASCAL, BASIC, JCL,PL-SQL.

MANAGEMENT: Budgeting, Project Management, Scheduling, Proposal Writing, Project Analysis

PERSONAL: Experienced with troubleshooting, Excellent communication/interpersonal skills, Energetic, hard working, reliable and adaptable, able to learn quickly

WORK HISTORY:

Confidential - Lake Forest, IL

SQL Server DBA

Responsibilities:

• Administrating, maintaining, and supporting SQL Server 2005, 2008, 2008 R2, 2012, and 2014 databases
• Writing SQL Server stored procedures in T-SQL as needed
• Performance tuning as needed.
• Provide 365x24x7 operation support for Confidential databases to ensure business running efficiently
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Enforcing all database logical and physical design guidelines and standards.
• Planning and setting up new servers by performing server provisioning, system configuration, installation and database migration
• Working closely with application development teams, responsible for code review, deployment and troubleshooting in QA/Prod environment
• Worked on capacity planning, high-availability and disaster recovery to meet growing business demands

Confidential, Deerfield, IL

SQL Developer

Responsibilities:

• Writing and supporting Posgres SQL code for healthcare insurance systems using SQL stored procedures and functions
• Writing specifications for projects
• Troubleshooting and fixing issues with code and databases
• Performance tuning as needed.
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Communicating with all levels of employees

Confidential - Deerfield, IL

SQL DBA/Developer

Responsibilities:

• Writing and supporting SQL Server 2012 SQL code for global payroll systems using TSQL stored procedures and functions
• Writing specifications for projects
• Troubleshooting and fixing issues with code and databases
• Performance tuning as needed.
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Communicating with all levels of employees

Confidential - Mundelein, IL

Consultant (ERP and Analytics Specialist)

Responsibilities:

• DBA/Developer to multiple databases in SQL Server 2008 R2
• Monitored jobs for performance and for failures
• Automate and refine processes using tools like SSIS
• Writing SQL Server stored procedures using TSQL
• Analyze end user database needs and provide efficient solutions
• Performance tuning as needed.
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning

Confidential - Elk Grove Village, IL

Consultant (ERP and Analytics Specialist)

Responsibilities:

• DBA/Developer to multiple databases in SQL Server 2012, Oracle 8i, MS Access and Essbase.
• Ensured database integrity and performance
• Monitored jobs for performance and for failures
• Automate and refine processes using tools like SSIS
• Writing SQL Server stored procedures using TSQL
• Performance tuning as needed.
• Provide 365x24x7 operation support for Aquion databases to ensure business running efficiently
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning

Confidential - Northbrook, IL

SQL Server DBA/Developer

Responsibilities:

• Supporting disaster recovery including database mirroring and replication
• Creating and maintaining jobs
• Designing and creating SQL Server tables.
• Assisting in SQL Server optimization including indexing and query optimization
• Assisting in transferring databases, including TempDB, to new servers using TSQL scripts
• Writing SQL Server stored procedures using TSQL
• Writing, updating and supporting reports using TSQL
• Analyze end user database needs and provide efficient solutions
• Editing XML

Confidential - Chicago, IL

Consultant DBA/Developer

Responsibilities:

• Creating and maintaining jobs
• Performing SQL Server optimization including indexing and query optimization
• Designing and creating SQL Server tables.
• Performing SQL Server performance tuning
• Writing SQL Server stored procedures
• Writing, updating and supporting SSRS reports
• Analyze end user database needs and provide efficient solutions
• Administrating, maintaining, and supporting SQL Server 2005, 2008, and 2008 R2 clustered databases
• Supporting databases on SQL Azure
• Writing SQL Server stored procedures as needed
• Performance tuning as needed.
• Provide 365x24x7 operation support for MC2 Energy Services databases to ensure business running
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Enforcing all database logical and physical design guidelines and standards.
• Creating and running deployment scripts for Production
• Working closely with application development teams, responsible for code review, deployment and troubleshooting in QA/Prod environment
• Creating update scripts for changing data in production
• Updating and repairing an MS Access 2010 application that uses SQL Server as a backend.

Confidential - Oakbrook, IL

SQL Server DBA/Developer

Responsibilities:

• Administrating, maintaining, and supporting SQL Server 2008 databases
• Writing SQL Server stored procedures in T-SQL as needed
• Performance tuning as needed.
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Enforcing all database logical and physical design guidelines and standards.
• Planning and setting up new servers by performing server provisioning, system configuration, installation and database migration
• Working on capacity planning, high-availability and disaster recovery to meet growing business demands
• Create and maintain data warehouses using SAP Business Objects
• Create reports using Cognos
• Administrating, maintaining, and supporting MySQL databases

Confidential - NorthLake, IL

Contract SQL Server DBA/Developer

Responsibilities:

• Administrating, maintaining, and supporting SQL Server 2008 databases
• Writing SQL Server stored procedures in T-SQL as needed
• Performance tuning as needed.
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Enforcing all database logical and physical design guidelines and standards.
• Planning and setting up new servers by performing server provisioning, system configuration, installation and database migration
• Working on capacity planning, high-availability and disaster recovery to meet growing business demands
• Installing and supporting Microsoft SCOM and DPM

Confidential - Hoffman Estates, IL

Contract SQL Server DBA

Responsibilities:

• Administrating, maintaining, and supporting SQL Server 2005, 2008, and 2008 R2 clustered databases
• Writing SQL Server stored procedures in T-SQL as needed
• Performance tuning as needed.
• Provide 365x24x7 operation support for Confidential Technologies databases to ensure business running
• Monitoring database performance, identifying performance bottlenecks on server resources or query code, and performing query tuning
• Enforcing all database logical and physical design guidelines and standards.
• Planning and setting up new servers by performing server provisioning, system configuration, installation and database migration
• Working closely with application development teams, responsible for code review, deployment and troubleshooting in QA/Prod environment
• Worked on capacity planning, high-availability and disaster recovery to meet growing business demands
• Worked with offshore clients

Confidential - Chicago, IL

SQL Server DBA\Developer

Responsibilities:

• Administrating, maintaining, and supporting SQL Server 2005 clustered databases
• Writing SQL Server stored procedures in T-SQL as needed
• Experience migrating SQL Server 2005 databases to SQL Server 2008.
• Performance tuning as needed.
• Provided 365x24x7 operation support for the Confidential SQL Server databases to ensure business running
• Monitored database performance, identified performance bottlenecks on server resources or query code, and performed query tuning
• Worked closely with application development teams, responsible for code review, deployment and troubleshooting in QA/UAT/Staging/Prod environment
• Worked on capacity planning, high-availability and disaster recovery to meet growing business demands

Confidential - Chicago, IL

Senior SQL Server DBA

Responsibilities:

• Administrated, maintained, and supported SQL Server 2008 clustered databases
• Wrote SQL Server stored procedures, SSIS packages
• Supported mirroring and replication
• Performance tuning as needed.
• Various Project Management responsibilities
• Provided 365x24x7 operation support for the Confidential databases to ensure business running
• Monitored database performance, identified performance bottlenecks on server resources or query code, and performed query tuning
• Managed and tuned the data warehouse system for BI team including SSRS, SSAS
• Enforced all database logical and physical design guidelines and standards.
• Evaluated new SQL Server features/tools
• Worked closely with application development and QA teams, responsible for code review, deployment and troubleshooting in QA/UAT/Staging/Prod environment
• Worked on capacity planning, high-availability and disaster recovery to meet growing business demands

Confidential - Palatine, IL

SQL Server DBA\Developer

Responsibilities:

• Administered, maintained and supported SQL Server 2000 and SQL Server 2005 databases
• Migrated SQL Server 2000 databases to SQL Server 2005
• Performed replication and log shipping.
• Wrote and modified SQL Server stored procedures, functions, SSIS packages, and DTS packages
• Created reports for SSRS, wrote triggers, supported replication, worked in virtualized environments
• Performance tuning as needed.
• Designing and creating SQL Server databases
• Some project management and light server administration experience
• Coordinated server backup maintenance and support calls
• Provided 365x24x7 operation support for the Harper databases to ensure business running
• Designed and implemented various SSIS and Replication solutions for internal data integration system
• Monitored database performance, identified performance bottlenecks on server resources or query code, and performed query tuning
• Enforced all database logical and physical design guidelines and standards.
• Planned and setup new servers by performing server provisioning, system configuration, installation and database migration
• Evaluated new SQL Server features/tools, planned various upgrades from SQL Server 2005 to SQL Server 2008/R2
• Worked with Cognos

Confidential - Downers Grove, IL

Database Support Specialist

Responsibilities:

• Maintained and supported SQL Server 2000 databases
• Wrote SQL Server stored procedures, modified and supported Excel VBA, ASP, and XML applications,
• Light server administration, coordinated server backup maintenance, support calls
• Assisted in support for Hyperion Enterprise, Hyperion Business Rules, Hyperion Reports, and Hyperion Financial Management.
• Worked with offshore clients

Confidential - Downers Grove, IL

Consultant (Database Developer)

Responsibilities:

• Modified and troubleshot existing MS Access applications,
• Developing and supported Excel VBA applications
• Created a small VB.net application, wrote and modified SQL Server Stored Procedures for an oil refinery.