We provide IT Staff Augmentation Services!

Sql Dba Resume

5.00/5 (Submit Your Rating)

Houston, TX

TECHNICAL SKILLS

Superb skills in: Microsoft SQL Servers (2000, 2005, 2008R2, 2012, 2014, 2016), DB2/UDB, MicrosoftA ccess, Quality Control, Testing, and Red Gate Monitoring

Expert in: SSRS, SSIS, SSAS, T - SQL, Crystal Reports, Microsoft Project, ETL, Perl, and UNIX/AIX Shell

Familiarity with: Oracle, Agile, Data Mining, and Warehousing

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL DBA

Responsibilities:

  • Help design and architect for SQL Server systems.
  • Disaster Recovery (Idera)
  • Report Development (SSRS)

Confidential, Houston, TX

SQL DBA

Responsibilities:

  • Designed and implemented project for upgrading over 100 SQL Server 2000 databases to SQL Server 2014 environment, including audit reporting and Microsoft project plan using best practices.
  • Used Microsoft Upgrade Advisor
  • Achieved databases
  • Designed and implemented best practices for 35 corporate SQL Servers environment, including risk assessment and configuration standards for enterprise and standard editions of SQL Server (2000, 2005, 2008R2, and 2012).
  • Created implementation plan of best practices and risk assessment tasks of SQL Server on Museum of Fine Arts, Houston.
  • Used RED GATE monitoring system for alerts and notifications of events.
  • Created Extraction, Transform and Load (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
  • Experienced using DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Confidential, Houston, TX

Systems Analyst/SQL DBA

Responsibilities:

  • Approved, scheduled, planned, and implemented the installation and testing of application software and improvements to computer systems.
  • Performed vendor software releases and updates.
  • Scheduled and executed all backup procedures. Company officer authorized for Homeland Security compliance.
  • Designed and implemented best practices for 50 corporate SQL Servers environment, including build out document and configuration standards for enterprise and standard editions of SQL Server.
  • Created risk analysis for corporate best practices on 50 SQL Servers. Consult for implementation and performance of SQL Server development on corporate claims application.
  • Data migration and conversion of DB2 and Access databases to SQL Server using BI SQL Server Integration Services (SSIS). Onsite technical lead.

Confidential, Houston, TX

SQL Server/DBA

Responsibilities:

  • Architectural technical support for development team.
  • Responsible for turnkey development and execution of company data warehouse. Duties included conceptual, logical, and physical design, ETL processes using HR data warehouse and retrieval engine.
  • Project management was supported using JIRA. Onsite technical lead.
  • Oversaw 230+ servers and 3,000+ databases.
  • Performed security, database builds, database restores, and database backups.
  • Business Intelligence Support Functions.
  • Risk analysis for 50 SQL servers. IDERA, SSIS, SSRS, and SSAS. Installed Idera software for backups and monitoring. Onsite production DBA.
  • Application support of General Ledger, Profit & Loss and Billing System on the company SQL Server.
  • Responsible for resolution of breakdown and data errors in all applications using SQL Transact and Query.
  • Company officer authorized for Homeland Security compliance.

Confidential, Houston, TX

QA Manager/DBA

Responsibilities:

  • Implemented bank check imaging software for confidential which has since become industry standard for all bank check imaging.
  • Developed testing infrastructure for world’s largest commercial digital archive.
  • Performed all server upgrades and releases for all environments.
  • Maintained all databases.
  • Developed SQL scripts for testing and analysis.
  • Created a database warehouse for data mining.
  • Performed and implemented all regression, stress, integration, production readiness and volume tests.
  • Planned and implemented system backups and maintenance site disaster recovery readiness.
  • Created COBOL programs for data manipulation of image test data.

We'd love your feedback!