Production Support Specialist Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

OBJECTIVES

( 1 ) MICROSOFT SQL SERVER Relational Database Management System (Expert-level:  all aspects and all versions, including 2005 and 2008):  Seek hands on work; will take on management roles as well.  ( 2 ) ORACLE, SYBASE, INFORMIX, MySQL, DB2 (INCLUDING UDB), DP2, INFORMATICA, AND ALL OTHER Relational Database Management Systems (Essentials-level:  select aspects and all versions):  Select aspects include but are not limited to database development, logical design, physical design, data modelling, table development, schema development, stored procedure development, data warehouses, and backup and recovery.  Seek hands on work; will take on management roles as well.  Possess CEO-level management skills.

 

EXECUTIVE SUMMARY

·        See http://sqlserversolutions.com for a practical demonstration of technical expertise.

·        Expert in Relational Database Management Systems (database sizes:  up to 10 terabytes):  Microsoft SQL Server for over 20 years (all versions, including 2005 and 2008), Oracle, Sybase, Informix, MySQL, DB2 (including UDB), and other RDBMs.  Recent responsibility for over 1,000 SQL Server databases (total database size: 10+ Terabytes) and for over 200 ORACLE databases (total database size: 5+ Terabytes).

·        Enterprise Application Areas: (business analysis, etc. in the areas of) Business Intelligence, CRM (Customer Relationship Management), Enterprise Resource Planning, Financials, Human Resources, Supplier Relationship Management, and Supply Chain Management

·        Enterprise Application Software: (business analysis, etc. using) BusinessObjects, J. D. Edwards, Oracle Financials, PeopleSoft, Platinum, SAP, and Walker Financials.

·        Environments & Languages:  Microsoft operating systems, Active Directory, Unix/Linux operating systems, Microsoft Visual Studio/other languages, and .NET environment

·        Personnel Interaction:  more than 25 years managing and interacting with end users in PC, client/server, minicomputer, and mainframe environments as team leader, project manager, and department head.

·        Experienced in several industries:  grade/high school/college teacher, computer-based testing, communications, distribution, education, financial, food, insurance, manufacturing, marketing, medical, real estate, sales, safety, software, steel industry, television, web-hosting.

·        Risk Management Expert

CONTINUE EXECUTIVE SUMMARY

·        Inventor of “Footprint Technology”:  Footprint technology allows you to check any number of performance/diagnostic metrics at a single glance using graphical spectroscopy.  Metrics are converted into benchmark/daily spectra and compared.  See “DEVRY” below.

·        Technology Website at http://sqlserversolutions.com.

·        President of IADBA (a DBA organization) at http://iadba.com.

·        President of HIPAFI (a HIPAA organization) at http://hipafi.com.

·        A technical assessment session (you present your needs, I present my relevant qualifications, and we assess whether I can meet your needs) is highly recommended.

·        A five-minute phone conversation to start the interview process is highly recommended.

·        President of WebPsyops, Inc. (web design and development) at http://webpsyops.com.

·        Some jobs/contracts listed below were coterminous.

·        Student (not anywhere near fluent) of several languages, including Hindi, Urdu, French, Spanish, German, Russian, Korean, and Chinese.

PROFESSIONAL EXPERIENCE

2002 – 2010

CHESAPEAKE ENERGY – Oklahoma City, OK	6-MONTH PROJECT
SQL Server/Oracle DBA/Production Support Specialist/Developer		5/10 – 1/11

Worked as DBA/Developer/Architect in the natural gas/oil industry, primarily for the purposes of developing and upgrading reports in SQL Server 2008 and Oracle 10g.

SQL SERVER SOLUTIONS – Schaumburg, IL	9-MONTH PROJECT
SQL Server/Oracle DBA/Production Support Specialist/Developer		7/09 – 5/10

Set up various SQL Server/Oracle 10g/Redgate backup, log shipping, and replication systems in a hands-on role and as team leader of a group of five database personnel.

SQL SERVER SOLUTIONS – Chicago, IL	SYSTEM MAINTENANCE
SQL Server DBA/Production Support Specialist/Developer		1/09 – 6/09

Conducted SQL Server/Oracle 10g system maintenance/monitoring/development in a hands-on role and as a team leader of a group of seven.

SONUS NETWORKS – Westford, MA		EMERGENCY CONTRACT
SQL Server Reporting Services & Visual Studio	11/08 – 12/08

Developed reports (SSRS) and the reporting environment/interface, which included Sharepoint in a hands-on role and both as team leader of a group of three report experts and as project manager for an interdept. group of fifteen, which consisted of a mix of report experts and end users.

WISCONSIN HEART HOSPITAL – Wauwatosa, WI		EMERGENCY CONTRACT
SQL Server Reporting Services & Visual Studio	8/08 – 11/08

Concentrated on development of SSRS reports involving SQL queries and XML and on the Eclipsys reporting environment/interface in a hands-on role and as team leader of a group of three.

SQL SERVER SOLUTIONS – New York, NY		MULTIYEAR PROJECT
SQL Server DBA/Production Support Specialist/Developer	Hospital Management	12/06 – 11/08

Migrated 10 instances of SQL Server 2000 to 64-bit SQL Server 2005, involving conversion of SQL Server 2000 DTS packages into SQL Server 2005 SSIS format.  523 DTS packages were migrated.  100 reports were prepared using SQL Server Reporting Services and Visual Studio 2003 and 2005.  XML query development and AJAX.  100 databases were inspected for:  HIPAA compliance in terms of providing correctness of health insurance information and ease of accessibility to both health insurance and general medical information.  My role involved 75% hands-on implementation and 25% activities of project manager.

IMS HEALTH – Philadelphia, PA	6-MONTH PROJECT
SQL Server Systems Analyst & DBA/Production Support Specialist	12/07 – 5/08

Analyzed entire SQL Server installation consisting of about 200 “SQL Server” servers for the purposes of training newly hired SQL Server DBAs in the management of these systems.  Critical areas included Data Flow, Data Protection, Data Warehousing (10 Enterprise Data Warehouses and 3 Financial Data Marts), Database Administration/Production Support, Database Development, Database Server Administration/Production Support (“SQL Server” Server Administration/Production Support), Database Server Development (“SQL Server” Server Development), Security, and System Administration/Production Support (Universal Processes).  My role involved both hands-on implementation and the activities of project manager.

CELTIC LIFE INSURANCE COMPANY – Chicago, IL		8-MONTH PROJECT
SQL Server DBA/Production Support Specialist/Developer/Instructor	8/07 – 3/08

Upgraded SQL Server 2000 databases to SQL Server 2005 in Vmware environment, established standards and wrote lengthy documentation in every area of Database Administration/Production Support for their Database Administration/Production Support Department, and instructed their DBAs in each of these areas.

SARA LEE, INC. – Downers Grove, IL	8-MONTH PROJECT
SQL Server DBA/Production Support Specialist/Developer – Consultant		10/06 – 5/08

·        Using Visio Pro with forward/reverse-engineering, modeled and designed Sara Lee’s new “Annual Operating Plan” application databases for a Windows 2003 and mixed 32-bit/64-bit

·        SQL Server 2005 environment.  Subsequently, built and tested the actual databases.  The SQL Server 2005 64-bit technology was critical to SSIS and SAS performance enhancement.

·        Configured Oracle/flat file integration with the AOP database using SSIS (SQL Server Integration Services) and created reports using SSRS (SQL Server Reporting Services).

·        Project manager over a team of ten personnel.

SQL SERVER SOLUTIONS – Washington, DC		MULTIYEAR PROJECT
SQL Server DBA/Production Support Specialist/Developer	United States Congress		4/06 – 10/06

Roles included that of team leader and project manager.  Responsible for:

·        Alerts	·        Analysis Services (OLAP Services)
·        Backup/Recovery, Batch processing	·        BCP/ETL/Export/Import
·        Best Practices (Microsoft Best Practices Analyzer)	·        Capacity planning
·        Clustering and redundancy design	·        Constraints
·        Daily maintenance, including DBCC (Database Consistency Checking)	·        Database maintenance plans
	·        Functions

DEVRY UNIVERSITY – Oakbrook Terrace, IL	8-MONTH PROJECT
Systems-Level SQL Server DBA/Production Support Specialist/Developer – Consultant	9/05 – 4/06

·        This position required system administrator, DBA/production support specialist, and developer skills.

·        Its focus was the upgrading, development, and administration of the SQL Server-supported PowerFAIDS financial services software that DeVry uses to disburse, monitor, and plan its

student financial aid services.  This included multiple upgrades to the SQL Server backend of

the PowerFAIDS application as part of regular upgrades to the PowerFAIDS application.

·        Handled all responsibilities relating to Sarbanes-Oxley compliance, including auditor interviews and the development of a custom, audit information database application.

·        Significant work was done in SSIS (SQL Server Integration Services [“DTS”]).

·        Developed the “CYBORTEL SQL Server Management Console” at CYBORTEL, Inc. and, then, customized and licensed the management console for use at DeVry University.  The Console contained access portals to SQL Server Enterprise Manager, Query Analyzer, and Profiler, access portals to the Microsoft Baseline Security Analyzer, the Microsoft SQL Server Best Practices Analyzer, and SQL Server Books Online, primary and secondary custom SQL DBA directory access portals, a variety of CYBORTEL, Inc. proprietary

technologies, including DBCC CheckDB GT Test, DBCC CheckDB Summary Report, Daily Performance Footprint, Performance Benchmark, Performance Snapshot Report, Capacity

CONTINUE DEVRY UNIVERSITY – Oakbrook Terrace, IL

Planning, Data File Size Daily Snapshot, Daily Diagnostic Footprint, Diagnostic Benchmark, and Server-Level Diagnostics, and access portals for the Benchmarks Library, Star Team, and

the DBA Electronic Scratch Pad.

·        Updated the SQL Server testing environment.  This included the duplication of multiple databases, along with their respective security accounts and logins.

·        Team leader for two groups – three personnel and five personnel, respectively.

·        Project manager for team of twenty-five during seasons of interdepartmental work.

SQL SERVER SOLUTIONS – Los Angeles, CA		MULTIYEAR PROJECT
SQL Server, Oracle, MySQL DBA/Production Support Specialist/Developer	Motion Picture Association		12/04 – 6/08

Responsible for:

·        DCL/DDL/DML	·        Devices, databases and logs – design, creation, and updating
·        Disaster Recovery
·        Documentation – policies and procedures	·        DTS (Data Transformation Services)
·        Hardware/RAID	·        Indexing
·        Index statistics updating	·        SQL Server Reporting Services
·        Management of a MySQL database serving as the backend for an on-line application

A. M. CASTLE & CO. – Franklin Park, IL	1-YEAR PROJECT
Oracle DBA/Production Support Specialist/System Architect & DBA/Production Support Specialist/System Architect Instructor & MS SQL Server DBA/Production Support Specialist/System Architect & DBA/Production Support Specialist/System Architect Instructor – Consultant		12/04 – 12/05

·        Upgraded their Oracle architecture from Oracle 8 to Oracle 8i, providing extensive, new functionality.

·        Optimized their Oracle NT Server production databases, emphasizing Oracle defragmentation/reorganization procedures.

SQL SERVER SOLUTIONS – Seattle, WA	MULTIYEAR PROJECT
SQL Server DBA/Production Support Specialist/Developer & Oracle DBA/Production Support Specialist/Developer & MySQL DBA/Production Support Specialist/Developer		8/04 – 12/04
		Microsoft Subsidiary

Responsible for:

·        Install/Configure/Support/Upgrade	·        Business Analysis
·        Logical/Physical/Data Modeling/Design (Schema)	·        Load balancing
·        Monitoring, including DBCC (Database Consistency Checking)	·        Migrations
	·        NT 4.0, Windows 2000 & 2003
·        OLAP (Data Warehouses [Data Marts] Star/Snwfl)	·        OLTP
·        Performance Tuning and Optimization	·        Query/Stored Procedure Optimization

GALLAGHER BASSETT SERVICES, INC. – Itasca, IL	6-MONTH PROJECT
SQL Server DBA/Production Support Specialist/Developer & SQL Server DBA/Production Support Specialist/Developer Instructor Consultant		¾ – 8/04

Provided installation of new technologies (CYBORTEL technologies) and instruction in these new technologies.  These included:

·        Microsoft Best Practices Analyzer	·        Microsoft Baseline Security Analyzer
CYBORTEL Data Performance Monitor  (Click here for slide show.)	·        CYBORTEL Advanced Analysis Services
	·        CYBORTEL Integrated Data Control System

·        The CYBORTEL Data Performance Monitor included all of the functionality of Windows NT Performance Monitor (Windows 2000 Performance Monitor, Windows XP Performance Monitor) and added additional, extensive, database-specific functionality.

·        The CYBORTEL Integrated Data Control System included all of the functionality of the Microsoft Best Practices Analyzer, the Microsoft Baseline Security Analyzer, and the CYBORTEL Data Performance Monitor.

·        Integrated legacy systems using Informatica.

·        Team leader of group of three – one DBA and two developers.

SQL SERVER SOLUTIONS – Miami, FL	MULTIYEAR PROJECT
SQL Server DBA/Production Support Specialist/Developer & Oracle DBA/Production Support Specialist/Developer & MySQL DBA/Production Support Specialist/Developer			10/03 – 2/04
		State of Florida

Provided database administration/production support/development/training and web development.  Role involved project management.  Responsible for:

·        Replication	·        Security (Microsoft Baseline Security Analyzer)
·        RDBMS end of architecture (2-tier, 2½-tier, 3-tier & other n-tier)	·        RDBMS end of web-based systems, including ecommerce solutions
·        RDBMS vendor relations	·        SQL (T-SQL, PL/SQL, etc.)

AON CORPORATION – Chicago, IL	1-YEAR PROJECT
MS SQL Server DBA/Production Support Specialist/Developer – Consultant		10/03 – 10/04

Role involved project management.  Responsible for:

·        Alerts	·        Backups
·        Database Maintenance Plans	·        DBCC (Database Consistency Checking)
·        Deadlocks	·        Disaster Recovery
·        Index Optimization/Index Tuning Wizard	·        Index Rebuild
·        Locks	·        Maintenance Plan History
·        Monitoring SQL Server Blocking	·        Nightly Batch File Validation Process
·        Performance Tuning and Optimization	·        Query Utilization Optimization
·        Scheduling	·        Shrinkfile

SQL SERVER SOLUTIONS – Dallas, TX	MULTIYEAR PROJECT
SQL Server DBA/Production Support Specialist/Developer & Oracle DBA/Production Support Specialist/Developer & MySQL DBA/Production Support Specialist/Developer			4/03 – 10/03
		Exxon Mobil Corporation

Provided instruction in SQL Server, Oracle, Sybase, and Informix.  Role involved project management.  Responsible for:

·        Scheduling	·        SSIS (SQL Server Integration Services [“DTS”]) ·        Integration of SQL Server/Oracle instances using Informatica.
·        Stored procedures (Procedures)	·        Tables, fields (columns), records (rows) - creation and updating
	·        Log Shipping
·        Triggers	·        Troubleshooting	·        Views

PROMISSOR, INC. – Evanston, IL	11-MONTH PROJECT
SQL Server DBA/Production Support Specialist/Developer/System Architect/System Administrator Consultant		6/02 – 4/03

Managed other IT professionals as a DBA/System Administrator.  Guided the work of 10 application developers.  Supervised 3 managers.  These 3 managers supervised 50 employees.  Managed multiple staffs, ranging in size from 1 to 10.  These staffs comprised the Database Administration/Production Support and System Administration/Production Support departments.

·        Project manager for group of fifty personnel.

·        Team leader of ten groups, ranging from three to twenty people.

·        Designed and implemented Performance Management Systems.  These systems tracked performance of memory, permanent storage (including SAN and EMC Symmetrix), central processing, and network components.

·        Built PMTA (the Performance Metrics Tracking Application), deriving metrics from tables in SQL Server 2000 and Oracle databases, populated by stored procedures in these databases.  The performance of web servers, OLTP Database servers, and DSS servers was monitored and tuned.

·        Integrated SQL Server, Oracle, Sybase, and DB2 data sources using Informatica.

·        Built auto-generating, graph software.  This software has the ability to present the same data in multiple, graph formats.

·        Designed and implemented QAI (quasi-artificial-intelligence) software applications. These applications are used principally for making projections in the areas of capacity planning and resource planning and involved the development of innovative projection and forecast methodologies.

·        Designed and implemented new disaster recovery plans.  This involved setting up three remote hosting locations.  These locations were handled through WorldCom Digex.

·        Adhered to ISO certification standards in all endeavors.

·        Designed and implemented three Veritas solutions, including backup, clustering, and disaster recovery.

·        Taught classes in database administration/production support, system administration/production support, and system architecture. These classes included SQL Server 2000 Windows 2000 Clustering and BMC Patrol Operations.  PowerPoint

CONTINUE PROMISSOR, INC. – Evanston, IL

·        presentations were prepared by me that could be used by individuals to learn on their own and by other instructors.

·        Instituted SourceSafe version control system.  This entailed setting up specialized directory structures.

·        Built Operational Data Stores, Data Warehouses, and Data Marts (stock market, accounting, marketing, sales, performance tuning, etc.).  Developed star, snowflake, and crystal schemas.

·        Installed Analysis Services on SQL Server 2000 Clusters on Windows 2000 Datacenter Servers.

·        Designed and implemented application deployment processes.  This included the insertion of deployment tables in scores of databases.

·        Used Novelle, NT, and Windows 2000 networking strategies.

·        Developed System Utilization methodologies.  This incorporated system optimization and system saturation processes.

·        Obtained Cost Saver Application analyses via Cray computer at the University of Texas.

·        Improved production server performance through memory reallocation.  The stored procedure cache was increased by a factor of eight.

·        Designed and implemented 100 DTS packages.

·        Designed and developed DP2 (the DTS Package Detector Program).

·        Performance tuned 2,000 stored procedures.

·        Designed and implemented new system architecture.  One objective of the new architecture was to improve performance by a factor of 10.

·        Utilized MDAC, Microsoft Data Access Components.

·        Set up maintenance plans for the OLTP and DSS servers running SQL Server 2000, including backups, rebuilding of indexes, and other maintenance tasks.

·        Reviewed and optimized database configuration options.

·        Implemented logical/physical database models/designs.

·        Developed schemas in Visio and ERWin for databases and data warehouses (incl. data marts).

·        Utilized Microsoft Project to manage a score of team projects.

PROFESSIONAL EXPERIENCE

1972 – 2002

My experience before 2002 will be found in a resume appendix at http://sqlserversolutions.com/appendix.htm.  Here is a list of the companies referenced there, many of which were fortune 500 companies and for which I worked either on a contractual or permanent basis.  The experience gained over the years at these and other companies has established me as an Industry Leader in Database (1) Administration/Production Support,

(2) Development, and (3) Architecture and, in particular, as a master DBA/Production Support Specialist/Developer/Architect in MICROSOFT SQL SERVER and a select master

CONTINUE PROFESSIONAL EXPERIENCE:  1972 – 2002

DBA/Production Support Specialist/Developer/Architect in all other Relational Database Management Systems (note “OBJECTIVES” section above on first page).

·        A. M. Castle & Co. Franklin Park, IL	·        EXS, Inc. Chicago, IL	·        Océ Chicago, IL
·        American Academy of Pediatrics Elk Grove, IL	·        General Electric Company Naperville, IL -----------------	·        Peoples Choice Cable TV Chicago, IL --------------
·        Amoco Corporation Chicago, IL	·        Graphics Systems, Inc. Chicago, IL	·        Rand McNally Skokie, IL
·        Aon Corporation Chicago, IL	·        Kraft Foods Northfield, IL	·        Rockford Electronics Rockford, IL
·        Arlington Industries Libertyville, IL ------------------	·        MCI WorldCom, Inc. Chicago, IL --------------	·        U.S. Office Products/The Systems House Des Plaines, IL
·        Chicago Board of Trade Chicago, IL --------------	·        Merchant Account Corporation Chicago, IL	·        U.S. Robotics (3Com Corporation) Morton Grove, IL
·        Computax, Inc. Chicago, IL	·        MicroPlus Consultants Chicago, IL
·        Daimler Chrysler Corporation Belvidere, IL	·        National Safety Council Itasca, IL -----------

EDUCATION

·        B.R.E., Education, Midwestern Baptist College

·        N.D., Psychiatry, Providence Christian Seminary

·        M.S., Computer Science, MicroTech Institute†

·        Ph.D., Applied Computer Science, MicroTech Institute†

·        Ph.M.D., Pneumiatric Psychiatry, Pneumiatry Institute†

†To establish this degree's meritability of “full faith and credit” contact your educational authority.  Every educational entity does not require recognition from CHEA (Council for Higher Education Accreditation) and/or the USDE (United States Department of Education).  If you cannot find information through your educational authority and/or if you need additional information on recognition of educational entities, you can contact me at mbisconti@aol.com.  Any information obtained through internet search engines is not necessarily reliable because internet search engines may cache web pages out of context and may not provide signifying graphics.

Download Resume Format