Sql Server Data

JAMES A. STOKES

Silver Spring, MD *****

**********@*****.*** (C)-240-***-****

PROFESSIONAL SUMMARY

A seasoned DBA with over 20 years of strong background with ORACLE, AND MS SQL SERVER. A seasoned contractor seeking a long term opportunity and the ability to contribute as a team member over a long period of time.

EDUCATION

B.S.E.E., University of Maryland

Specializing in digital systems for aerospace technology

College Park, MD 1979

Database: Oracle 10g, 11g, SQL Server 2005,2008 R2, 2012, PostgreSQL, MySQL

Languages: PLSQL, TSQL, Psql

Hardware: Windows 2008, 2012, 32 & 64-bit, Unix Solaris, Centos Linux

Shell Scripting: Python & Bash

PROFESSIONAL EXPERIENCE

Dept of Veterans Affairs 4/2016-CURRENT

Sql Server/Oracle DBA Washington DC

Database Migration between life cycle phases (development, validation, staging, and prod).

Backups, restores & of databases

Sql Server 2012 with Always-On & Oracle 11g to DISA STIGS

DEPARTMENT OF LABOR 11/2015-4/2016

PostgreSQL DBA Washington DC

Designing, configuring and implementing new database-related projects for Department of labor

Database Migration between life cycle phases (development, validation, staging, and prod).

Stored procedures and functions (switching between the two).

PostgreSQL database development and maintenance.

Scheduling database jobs using Linux cron jobs via shell scripting and Python

Writing database queries based on requirements.

Query optimization, performance tuning.

Troubleshooting ETL operational data feeds

Backups, restores & of databases

Shell Scripting in Python & bash

DC PUBLIC HOUSING 08/2015 - 09/2015

System Analyst (short term contract) Washington DC

Software development experience.

SQL Server database maintenance.

Data warehousing data loads

Scheduling database jobs using SSIS packages.

Writing database queries based on requirements.

Query optimization, performance tuning and SQL Profiler.

Backups, restores

PENSION BENEFIT GUARANTEED CORPORATION 05/2015 - 08/2015

Database Administrator (short term contract) Washington DC

Designing, configuring and implementing new database-related projects for Pension Benefit Guaranteed Corporation

Software development experience.

Database Migration between life cycle phases (development, validation, staging, and prod).

Stored procedures and functions (switching between the two).

SQL Server database maintenance.

Scheduling database jobs using SSIS packages.

Writing database queries based on requirements.

Query optimization, performance tuning and SQL Profiler.

Backups, restores & of databases

AMERICAN FEDERATION OF TEACHERS 09/2014- 03/2015

SQL Server DBA (short term contract) Union Station, Wash DC

Designing, configuring and implementing new database-related projects for American Federation of Teachers

Database Migration between life cycle phases (development, validation, staging, and prod).

Stored procedures and functions (switching between the two).

SQL Server database maintenance.

Scheduling database jobs using SSIS packages for datamarts & OLAP Cubes

Writing database queries based on requirements.

Query optimization, performance tuning and SQL Profiler.

Backups, restores

SOCIAL SECURITY ADMINISTRATION 07/2014 -09/2014

SQL Server DBA (short term contract) Washington DC

Designing, configuring and implementing new database-related projects for Social Security administration.

Extensive knowledge of Microsoft SQL Server 2012 and work without supervision.

Database Migration between life cycle phases (development, validation, staging, and prod).

SQL Server LINKED Server.

Writing dynamic SQL

Stored procedures and functions (switching between the two).

SQL Server database maintenance.

Scheduling database jobs using SSIS packages for data warehousing schemes & OLAP Cubes

Writing database queries based on requirements.

Query optimization, performance tuning and SQL Profiler.

Backups, restores, and clustering of Geospatial databases

Analyzing, reviewing, and altering existing programs to increase operating efficiency and adapting to new requirements.

Providing technical and operational expertise and leadership to the SSA team.

Recommending, constructing, and implementing policies, procedures, and guidelines in the development and delivery of database solutions to the client.

Providing guidance to a cross-functional team, and acting in a consulting capacity.

Conducting the formulation of solutions to customer problems based on prior experience and hands-on understanding of how the database supports SSA goals.

Documenting software

Shell Scripting in Python & bash

ROCK CREEK STRATEGIC MARKETING 09/2013- 02/2014

DBA (position defunded) Washington DC

Software development experience.

Designing, configuring and implementing new database-related projects for Consumer Financial Protection Board.

Troubleshooting and resolving problems with new and existing database servers and databases.

genesis Supporting new and existing databases. Ensure deliverables are timely and meet QASP standards.

Install, configure and administer databases such as MySQL or PostgreSQL Enterprise database. Implement database backups, replication and user access.

Tune database servers for optimal performance. Work with developers and data scientists to define best strategies for data access (expert knowledge of SQL queries and SQL performance is required).

Implement monitoring, analysis and troubleshooting of database servers.

Centos (Linux)

Shell Scripting in Python & bash

HEALTH AND HUMAN SERVICES ADMINISTRATION 12/2012- 06/2013

Oracle DBA/ Sql Server DBA (Sequestration) Washington DC

Technical experience working with user groups to solve business problems with available technology including hardware, software, and databases for Health and Human Services.

Technical lead experience directing and managing activities of others.

Technical experience related to studying and analyzing system’s needs, systems development, systems process analysis, design, and re-engineering.

Has skills and experience related to business management, systems engineering, and operations.

Day-to-Day Operations in support of Oracle production environment with UNIX shell scripting

Proficient in database design and development

ETL of Oracle 11g to Sql Server 2008

Prototyping of Pentaho for ETL operations

Use of Data warehousing techniques & OLAP Cubes for Reporting

DC GOVERNMENT 10/2012-12/2012

Sql Server/ Oracle DBA (short term contract) Washington DC

Migration of Sql Server 2005 databases to Sql server 2008R2- 64 bit for DC Government.

Migration of Oracle Oracle DBA and PL-SQL development are plus.10g to Oracle 11g- 64 bit

Excellent communication skills and strong customer focus exhibited.

Experience in SQL Server database administration; PL/SQL programming skills

High level of initiative and dedication

Ability to work independently once given general direction

Outstanding customer service and interaction skills, as well as excellent verbal and written communications skills are required.

Skilled in acquiring knowledge in other business areas, demonstrating strong team building skills, adapting to unexpected changes and being a strong role model.

CENTER OF MEDICARE MEDICAID 07/2011-10/2012

Sql Server/ Oracle DBA Washington DC

Participates as part of a team maintaining database servers for Center of Medicare Medicaid.

Migration of Sql Server 2000 databases to Sql server 2005

Mostly a large, enterprise Oracle system in a dynamic, research oriented healthcare and scientific IT division of CMS.

Position involves hands on database configuration for managing databases, installing and upgrading database server and application tools; and involves some data layer software and data object development for MS SQL Server and Oracle

DBA work involves good RDBMS fundamentals; modifying the database structure as required by solution architects/developers; creating primary database objects (tables, views, indexes) from scripts or application design; controlling and monitoring user access to the database.

Pro- active management of production database systems and risk mitigation; Monitoring and optimizing the performance of the database; Backing up and restoring the database; Maintaining archived data on appropriate storage devices.

SQL query and stored procedure development, job automation, multi-table joins and query optimization

Good communications and analytical skills..\

ETL of flat files via SSIS for data marts & OLAP Cubes

Proficiency in the use of Oracle 11g on Unix

DISA STIGS remediation of Oracle & Sql Server databases

NATIONAL INSTITUTE OF HEALTH 01/2010- 07/2011

Sql Server/ Oracle DBA Washington DC

Participated as part of a team maintaining and developing web based software applications for National Institute of Health.

Mostly MS SQL Server environment with a large, enterprise Oracle system in a dynamic, research oriented healthcare and scientific IT division of NIH.

Position involved hands on database configuration for managing databases, installing and upgrading database server and application tools; and involves some data layer software and data object development for MS SQL Server and Oracle

DBA work involved good RDBMS fundamentals; modifying the database structure as required by solution architects/developers; creating primary database objects (tables, views, indexes) from scripts or application design; controlling and monitoring user access to the database.

Pro- active management of production database systems and risk mitigation; Monitored and optimized the performance of the database; Backing up and restoring the database; Maintaining archived data on appropriate storage devices.

SQL query and stored procedure development, job automation, multi-table joins and query optimization

Good communications and analytical skills.

Advise project managers, business analysts and customers regarding best technical practices.

Migration of Oracle 9i to Oracle 11g in a VMWare environment.

ETL of files from various services for data warehousing data reporting & OLAP Cubes

Migration of Sql Server 2000/2005 databases to Sql Server 2008

Proposal effort for migration of databases to PostgreSQL Enterprise database

SAVANTAGE SOLUTIONS 01/2008 – 10/2009

Oracle / SQL Server DBA (Laid Off) Washington DC

Performed all aspects of database administration for managing SQL Server 2005 databases

Proficient in planning, analysis, designing, and constructing databases.

Knowledge of industry standards and best practices for database security and capable of analyzing and defining database and information security requirements.

Developed database queries, applies patches and fixes, performs backup/recovery, tunes database and creates database schemas.

Developed SQL queries, back-end programs, Oracle user permissions and grants, and Oracle security.

Implementation and ongoing support of an Oracle 10g database

Performance tuning for complex queries and data structures.

Advanced usage of T-SQL, Triggers, Procedures, Functions for data transformation

Community of National Service 03/2007 – 10/2007

Oracle DBA Bankruptcy Washington DC

Assisted in defining file organization, indexing methods, and security procedures for specific user applications for the Community of National Service

Provided assistance in designing the logical data model and physical data model.

Executed performance tuning activities of installed Production Database.

Integrated and import data from multiple platforms and applications into an existing centralized data store.

Designed, developed and deployed applications and databases on multiple platforms for mainframe and Windows enterprise environments

Implementation and ongoing support of an Oracle 10g database to the Community of National Service

performance tuning for complex queries and data structures.

Ability to use Erwin Data Modeling Tools

Extensive use of PL/SQL.

DEPARTMENT OF JUSTICE 09/2006- 03/2007

SQL Server DBA Washington DC

Advanced T-SQL scripting for stored objects of Sql 2005 databases for the Dept of Justice

Analyzed database and information security requirements.

Developed database queries, applied patches and fixes, performed backup/recovery, tuned database and creates database schemas.

Developed SQL queries, back-end programs, user permissions, grants, and security.

Reverse-engineered of databases to the logical & physical data model.

Advanced usage of T-SQL, Triggers, Procedures, Functions

Reverse-engineering of Crystal Report for Impact analysis

ETL of flat files for data marts

CENTER OF DISEASE CONTROL 09/2005 -09/2006

SQL Server DBA Washington DC

Advanced usage of T-SQL, Triggers, Procedures, Functions ODF Sql 2000 databases for Center of Disease Control

DTS package development for ETL deployments

ER-Win data modeling for database design document

Use of Rational Rose approach to for design, test and release documentation

ETL of flat files for data warehousing & OLAP Cubes

DEPARTMENT OF DEFENSE 03/ 2004- 09/2005

Oracle Developer Washington DC

Maintenance of DOCEX application code using Oracle 9i views for reporting via Crystal Reports for Dept of Defense.

PLSQL Developer is used as a development tool

Implementation and ongoing support of an Oracle 10g database

Performance tuning for complex queries and data structures.

Migration of legacy system to .NET

RESUME TRUNCATED DUE TO LENGTH genesis

Contact this candidate