Summary:

I am a senior level analyst working within a team of Database administrators where I design, establish and program methods, practices, and procedures to develop and assist the migration, development of and, or improve Information Technology systems and staff with a full range of Database Administration functions, security, backup - recovery, development of new relational database management systems, databases, EDW data warehousing, web applications, reports and reporting services within new or updated environment s in Windows 2008 R2/ SQL Server High Availability, both clustered and non-clustered, Windows 2005/ Windows server 2003, Delphi, Sybase/ UNIX, Oracle RDB/ VAX, Oracle/ Windows, Oracle/ UNIX and DB2 UDB/ windows. I have migrated and, or designed and developed reports using crystal reports, SSRS with Visual Studio, SSIS, each requiring managed flow of information throughout the organization's team members, coordinating the dates, times, milestones, testing, training, and making the deliverables by the deadlines set or agreed upon to while making them transparent to the users as possible. I've researched, tested, migrated - our environments, databases and objects, web applications to new versions of operation systems and management software, clients, and utilities.

• Customer Service work with clients, peers, IO T personnel, and customers to assess IT needs, provide expert technical information or assistance, resolve complex or non-routine problems, and I'm committed to providing quality IT products, services and customer support to all.
• Communications listen intently to the customers' concerns, issues, and ideas and express my thoughts clearly, in a logical, analytical sequence, making clear and convincing oral and written presentations, taking into account the audience and nature of the information.
• Problem Solving thorough utilizing problem solving to identify IT-related problems using a variety of materials and sources to research, gather and apply technical information to determine accuracy and relevance to complex problems using sound judgment to generate and evaluate alternative methods of resolution to complex issues. I make sound decisions and, or recommendations that influence IT policies or programs that apply to both, new developments, or previously unresolved problems.
• IT Knowledge - demonstrate knowledge in applying, advanced information technology principles, concepts, methods, standards, and practices for variety of IT activities on a multitude of platforms. Ability to keep abreast of new and emerging technologies relating to IT systems software and to provide expert technical advice, guidance, and recommendations verbally and in writing to peers, supervisors and other government contractor personnel.
• Attention to Detail - ability to exercise resourcefulness, versatility, ingenuity, originality, and conscientiously paying attention to detail when performing daily tasks, or planning, organizing, and executing IT processes, migrations, and implementations.
• Security - I enable and ensure that IT Security policies established high-level rules to protect a company's technology resources and that the data stored by those resources exist are enforced at many different levels in our organization. I enable and ensure that users, groups, procedures and applications have only the very minimum access granted to fully satisfy to access all data/ information for all clients without error. Ensure that all access is promptly removed when access or privileges has been rescinded. I fully support and exercise all percussions to ensure that all aspects of CRISP continuous readiness in information security program are fully followed and enforced.

• I take a proactive approach to monitor and verify daily: service availability, jobs that include backups, windows, batches, and database level agent , checking the event logs for applications, security and system for warnings and errors , SQL server 2000, 2005, 2008, and 2012 error logs, disk space availability, and the system performance.
• Create schema objects tables, constraints, indexes, views, sequences, etc. and data types for complex applications that interface with other applications or that are mission critical to the client agency. The primary DB application Vista Oracle RDB that is very large and is hierarchal. Interacting with these databases is not efficient, so we down the databases to SQL server and update those parallel tables daily for all of our third party applications, reports through SSIS, generating subscriptions for end-users where the data is exported to Excel and posted on share folders where the end-users can reformat and push their reports to the appropriate departments.
• Utilized data modeling tools such as CA Erwin for logical and physical data modeling, forward and reverse engineering, comparisons to understand the differences between the model files, active model templates to derive new models changes so that they can be used to synchronize automatically to deliverable models, model repository and version features that supports metadata governance, versioning and multiuser modeling, then the API application programming interface to automate the task that involves reading and writing of the data model s .
• Lead and, or participated in the planning, scheduling and gathering information on all aspects of requirements analysis, specifications and design of custom-developed web based applications, report generation services, and other automated processes using SSRS reporting services .
• Create SSIS packages, jobs, functions and procedures to move, create, or update data/ views that interface with our Oracle RDB databases/ Vista utilizing clients Cache'/ KB Sql to Sql Server and other applications and that are mission critical to the client agency and supporting staff.
• Designed, wrote, tested, and deployed stored procedures implemented as a series of SQL statements which are conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed. In which these SQL statements and conditional logic becomes part of a single execution plan on the server and the results passed across the network instead of the whole statement in a packet for improved performance.
• Analyze risks and recommend strategies, policies and actions for database tuning. Define settings that reduce or eliminate downtime of critical applications and/or systems used by multiple agencies.
• Worked with the project lead as the DBA/Data modeler, and at time was the project lead, to document the technical design, develop, test and publish Sql Server Reporting Services and other related reports.
• Created, migrated and maintained OLAP cubes Online Analytical Processing data cubes using SQL server tools which are computer based technique for analyzing business intelligence/ data.
• Provide support and maintenance of existing Development, Quality Assurance and Production DB2 UDB /Windows 2003 installations that was the host for all web based internet financials for DNR to include forestry, licensing, land sales, forestry personnel, and management of all state owned land.
• Responsible for providing all IT security and database services and support for staff and IT equipment along with creating detailed procedures in accordance with industry best practices specifically for the planning, delivery, implementation, and execution of IT services.
• Installed, troubleshoot, support, and update third party software, applications, clients, and programs such as Pyxis, Pandora OMNI Cell , all DSS apps, VEBECS, Research, and Telecom on 32 and 64 bit platforms/ environments.
• Analyze databases and plan for proper tuning i.e. reducing I/O contention, identifying index candidates, reorganizing databases, tuning production SQL statements, monitoring statistics using SSAS Sql server Analytical Services .
• Monitor existing DB2 environments and troubleshoot performance and connectivity issues.
• Setting up DB2 database jobs to ensure database consistency checks, copy/ exchange/ move data, update index statistics for performance and all other required tasks to ensure a stable database and environment. Write the scripts and windows scheduled tasks to execute these processes.
• Create and Configure DB2 instances in all types of environments I/e test, training, quality assurance, development and production.
• Create and Modify DB2 Databases and Table spaces and the objects they contain.
• Perform DB2 database Exports/Imports to keep the development, test and production areas similar, provide complete test/ development environment, and, or restore datasets required for a complete testing of all application functionality.
• Recreate Development and QA Environments from Production for DB2.
• Project manager that researched and performed DB2 Server and DB2 Client Installations and configure database connectivity for a wide variety of applications.
• PL/SQL writing incorporated with UNIX scripting.
• Provide support for department of Agriculture's Oracle 12g databases when the primary DBA is absent that included user s setup security, backup verification and any problem solving/ resolution required.
• Setup, upgrade, apply patches, troubleshoot, and maintain system and database security for user logins, groups, and applications to ensure the integrity and security.
• Installed clients DB2, Oracle, etc. , developed silent install batch files for catalogs/ ODBC drivers, and ensured client connectivity enforcing security policies for multiple applications over several platforms used by state wide intra/ internet applications. Analyze issues, identify solutions, plan strategy for efficiently executing projects of complexity, and evaluate results.
• Business process reengineering and execution through development of insight into current business procedures and operations. Utilize technology to drive business change through modernization for greater organizational efficiency and value.
• Write/ create DTS and SSIS packages for SQL Server 2000, 2005 and 2008.
• Setup and maintain immediate transactional replication for SQL Server 2005 on a clustered environment for another clustered remote report server.
• Migrated all databases changing collation , writing the scripts to transfer the data, upgrading/ writing DTS packages to SSIS, VB scripts, secured objects and moving all scheduled jobs/ maintenance plans to the new clustered SQL Server 2008 environment running on Windows 2003 OS.
• Responsible for the availability and performance of eight Sybase ASE12.5.3 and ASE 15.5 production servers hosting 172 databases on SRDF disks using synchronous writes to a disaster recovery host , five QA/ test, and one training server on five UNIX/ Sun Solaris E25K Solaris10 platforms for MDOC including data warehousing, an EA server hosting their WEB sites and four SQL Server SQL Server 2005 servers hosting the AG/ Legal files, production, test and archive databases running immediate replication.
• Lead and, or participated in the planning, scheduling and gathering information on all aspects of requirements analysis, specifications and design of custom-developed web based applications, report generation services, and other automated processes.
• Performed the modeling solution we used every day in our business intelligence, master data management, data governance, data warehousing and data integration projects using Embarcadero - DB Artisan to meet the customer's needs, by helping improve data quality, reduce management costs, and building better applications.
• I completed the migration from the old Unix hosts to the new E25K 10TB environment that included the transfer of the data, building the whole environment, and ensuring the functionality of the maintenance plans and MDOC applications to include the transferring of all objects, users and their security credentials, scripts, procedures, packages, jobs/ shell scripts, building the CRONTAB job scheduler , applications, and data to the new environment and ensure their consistency with all policies and procedures.
• Michigan Department of Corrections wanted all data including the original entries, so we wrote, updated and improved an audit database server that tracked all changes to the data and notifications using shell scripting to generate the audit table and trigger builds. BCP the data into the new tables also using shell scripts.
• Strategic initiatives in modernizing the systems deployment process procedure into phases and implement effective version controls. Maintain standard configurations for window severs/ computers and test and verify network equipment which utilized a structured security patch management process for Integration and Testing, group controls, and audit reporting to ensure meeting both security and performance objectives.
• UNIX scripting for daily data migration from their main frame databases to the current, daily maintenance, building the web's display data, data warehousing, and the backup/ recovery of all data.
• Upgrades, patches and service packs of both SQL server and Sybase.
• Responsible for providing all IT security and database services and support for staff and IT equipment along with creating detailed procedures in accordance with industry best practices specifically for the planning, delivery, implementation, and execution of IT services.
• I design wrote, modified, documented and was the sole support all of the department's standalone MS Access VB and Paradox Object PAL Delphi prisoner movement applications/ databases, including the MDOC education reporting system for federal reimbursement that included troubleshooting, repair, and any required enhancement.
• Migration of new data into the new AG Legal Files databases along with the performance and tuning of all servers using SSAS and query analyzer to improve performance.
• Develop and tune replication for the AG production data to a remote reports server using immediate transaction replication.
• Mapped data from three existing systems to a new Professional License 2000 Oracle 8i system on HP UNIX environment.
• Consulted the existing system users to develop a plan of action to convert from existing systems to a new combined system for professional licenses.
• Setup and maintain immediate transactional replication for SQL Server 2005 on a clustered environment for another clustered remote report server.
• Wrote/ create DTS and SSIS packages for SQL Server 2000 and 2005 using visual studio 2005, VB scripts and designed, wrote and implemented report server SSRS reports for several departmental areas.
• Developed and wrote scripts to organize the three existing system's data to common file formats using Paradox, PAL, Access, SQL/PLSQL, TOAD, and other utilities.
• Developed and documented functions and procedures PL/SQL to load the common files into the Oracle database.
• Designed and wrote a series of reports and procedures Paradox, Access, Crystal Reports, SQL, PL/SQL , and form for the staff update their three existing systems to the new system's format.
• Re-wrote and developed a series of reports in Crystal Reports from the existing systems and to adapt to the new Oracle database.
• Developed Crystal reports for other application using a multitude of ODBC drivers.
• Developed a series of reports to inform construction license holders of expired fee notifications and processes to update that system when the fees where paid.
• Responsible for maintaining, and if needed the recovery, for 73 local and 5 central Oracle RDB databases on a variety of VAX/VMS platforms.
• Perform upgrades, re-organized/ sized databases and refresh indexes.
• Developed and updated a series of reports, tools and procedures to maintain data integrity.
• Maintained the data dictionary throughout a series of application upgrades using MS Access.
• Provided customer support for users encountering errors within the application caused by missing or corrupt indexes/ data, application problems, then insolated the error and made the corrections. The errors were reported directly to me, and other members of the DBA team, or through a Remedy reporting system. If the error was caused through the application, I duplicated the error through the application, documented what caused it, and worked with development to correct the problem.
• Maintained the Remedy database on an Oracle/ NT platform.
• Maintained the data dictionary throughout a series of application upgrades using MS Access.
• Developed and updated a series of reports, tools and procedures to maintain data integrity.
• Perform upgrades, re-organized/ sized databases and refresh indexes.
• DBA responsible for maintaining, and if needed the recovery, for 73 local and 5 central Oracle RDB databases on a variety of VAX/VMS platforms.
• Trained new database analysts in the department's environment, programs, applications, processes, and procedures.
• Worked with the data warehouse department to help develop their processes.
• Responsible for updating/ cleaning post conversion data that was converted from a county's old system to the new using a series of reports, tools and procedures developed to be ran in batch processes to minimize the impact on the offices work flow using DCL, RDO, SQL, and other tools.
• Provided customer support for users encountering errors within the application caused by missing or corrupt indexes/ data, application problems, then insolated the error and made the corrections. The errors were reported directly to me, and other members of the DBA team, or through a Remedy reporting system.
• DBA that maintained the Remedy database on an Oracle 8i / NT platform.
• Mapped data from their existing systems to a statewide DB2/ IBM/IMS cluster system.
• Consulted with the county existing system users to develop a plan of action to migrate/ convert from their existing systems to a new statewide system for the Child Support Enforcement offices.
• State of Ohio, Department of Technology Resources Office of Child Support Enforcement
• Trained new database analysts in the department's environment, programs, applications, processes, and procedures.
• Worked with the data warehouse department to help develop their processes.
• Responsible for updating/ cleaning post conversion data that was converted from a county's old system to the new using a series of reports, tools and procedures developed to be ran in batch processes to minimize the impact on the offices work flow using DCL, RDO, SQL, and other tools.
• Developed and wrote scripts to organize the existing system's data to common file formats using Paradox, Delphi, PAL, COBOL, CICS, File Aid, SPFPC, MS Access, VB, VB scripts and other utilities.
• Developed and documented functions and programs COBOL to load the common files into the centralized database.
• Designed and wrote a series of reports and procedures to update data from their systems to a common format.
• Re-wrote and developed a series of reports from the existing systems and to adapt to the new statewide centralized database.
• Developed a data collection tools Paradox/ PAL and, or MS Access, VB, VB scripts that was used to collect data that was needed by the statewide system but was not on their current system.
• Special OPS NCO, Fire Control NCO - TACFIRE, Instructor, and Section Chief 1989 1991
• Battalion Fire Control NCO - TACFIRE, squad leader/ section chief, Operations, and Instructor 1991 1992
• Developed and wrote the State's problem entry program that recorded and assigned problems with the statewide system for both the Department of Social Services and the Office of Child Support Enforcement. Wrote the scripts that would convert the data collected into the required Remedy format that would be implemented on a future date.
• Wrote the support documentation to support the data collection tool.
• Installed, implemented and trained the county's personnel on the use of the data collection tool.
• Gunnery instructor, TACFIRE instructor, mobile training team member for the US Field Artillery School 1986- 1989