We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

PROFESSIONAL SUMMARY:

Long time IT professional with a multi - disciplinary history of success;,, and broad Information Technology experience necessary to excel in new challenges and responsibilities. experience and successes are in Database Development, Administration, and ETL s in networking hardware, Cloud/AWS (Pentagon “Mil-Cloud”) web development (CBP NOC Dashboard), programming team lead (CBP Python Data Visualization Prototype) management experience including US Federal management and regulatory documentation.

TECHNICAL SKILLS:

  • MS SQL Server 2000/2005/2008 r2/2012/2014
  • Oracle R12 Discoverer
  • SAP Business Objects XI
  • C, C++, Java, SQL, Python, Javascript
  • Proficient at an advanced level in MS Office, (Word, Excel, PowerPoint, Access, Outlook).
  • Web Author/Design using HTML, Macromedia Dreamweaver

WORK EXPERIENCE:

SQL Server Database Administrator

Confidential

Responsibilities:

  • SQL Database Administrator in an SQL Server clustered Enterprise Data Center
  • Monitor and support a federal data center comprised of 3 enclaves, multiple SQL Server clusters in an always on environment
  • Perform routine backup and restore functions and ad-hoc backup and restores to support the enterprise environment customers.
  • Plan and implement SQL Server version upgrades
  • Plan and implement SQL Server migrations
  • Microsoft SQL Server 2012/2014 exam 70-461 boot-camp
  • Microsoft SQL Server 2012/2014 exam 70-462 boot-camp
  • Responsible for ETL, maintenance, operations, and optimization of:
  • SQL Server 2014 DB
  • MongoDB database
  • PostgreSQL database
  • Linux Administrator for secure virtual environment (MilCloud)
  • 9 Linux servers
  • AWS structure for migration of existing financial applications
  • Apache
  • Tomcat on DoD
  • MongoDB database
  • Windows System Administrator for multiple Windows servers both in production and test environments

Confidential

SQL Server Database Developer

Responsibilities:

  • Tableau Administrator, Tableau database reporting application, Administer user list, logins, roles and access

Confidential,

DBA and Application Developer

Responsibilities:

  • Lead on a $500 Million dollar, multi-year Java development project leading a team comprised of a Professor at Confidential and his research team to automate and maintain the Nuclear Radiation Sensor network nationwide
  • Lead on a Remote Satellite-Modem project to support the Nuclear Radiation Sensors. Researched, designed, obtained proprietary access to Confidential satellite networks and commercial grade DOD/DISA certified satellite modems and successfully transmitted proprietary formatted sensor data via satellite to military ground station for secure transmittal via secure government network to analysis office
  • Lead - Application Designer on a Python big-data visualization development project in support of the Nuclear Radiation Sensor project.
  • DBA team member on data mining and data warehouse design project for a 100 TB dataset of sensor data
  • Instrumental on re-writing critical SQL queries to optimize run-time and lessen impact on database services and other user organizations
  • Database designer using Enterprise Architect, Tableau, and other tools to design, diagram, and document progress of front-end applications and configure the database backend
  • Database analyst and report writer for proprietary Customs and Border Protection (CBP) very large database
  • Analyze and suggest updates/ modifications to enhance and optimize the db and/or result sets
  • Research and prepare documentation and staffing recommendations for staffing-up Data Analysis Center for Threat Evaluation and Reduction (DAC-TER) (CBP) utilizing Department of Homeland Security guidelines and procedures
  • Prepare presentation and for new data warehouse functions and data marts additions to CBP database
  • Daily ETL operations using Oracle R12, Oracle Discoverer, and SAP Business Objects to access military personnel database (MILPDS), and federal civilian personnel database (DCPDS)
  • Working closely with Air Force personnel gathering requirements for complex ad hoc SQL queries to produce reports to specifications on request.
  • Test, monitor and optimize database queries and tables
  • Produce technical design documentation from requirements: Working closely with Air Force personnel gathering requirements for ongoing improvements to proprietary client-server application
  • Liaison with Air Force Board Secretariat and Senior Leader Personnel Operations Administration
  • Documented and Certified the Promotion Board results for all SR personnel listed above for Congressional review

Web Content Developer

Confidential

Responsibilities:

  • Develop, upgrade and maintain secure web portal and supporting database for a U.S. Customs and Border Patrol, using AJAX, Java, JavaScript, SQL, MySQL, and SQL Server
  • Maintain and update existing Secure Web Portal/Network Operations Center dashboard using Java, JavaScript and SQL
  • Produce technical design documentation from requirements: Working from user requirements, upgrade and develop content for web portal
  • Perform maintenance, updates, and user logins and roles on sql server databases that support web portal functions
  • SQL Server DBA: Administer user list, logins, roles and access to secure web portal

Project Management Information Systems Manager

Confidential, Chantilly, VA

Responsibilities:

  • Responsible for the update and maintenance of the Project Management Information System
  • Perform Daily ETL procedures from multiple sources for Confidential
  • Design SQL queries and reports to support the project control office
  • Designed and implemented MS Access databases
  • Evaluate and recommend IT services and equipment

Information Systems Analyst

Confidential, Manassas, VA

Responsibilities:

  • Administrative and database support to IDP Lab, Production and Test unit
  • Assist in inventories, audits, data input
  • Database administrator: operation and maintenance of 5 SQL based proprietary databases
  • Design and implementation of MS Access databases in support of Sonar Lab operations
  • Rack Server Technician: service and upgrade of rack servers for deployment to U.S. Nuclear Sub Fleet

Hire Now