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.