Database Developer - Dba Resume
Deerfield, BeacH
SUMMARY:
Highly motivated and resourceful SQL DBA with a solid record of developing and supporting successful projects. Proficient SQL BI - SSRS developer with a wide-ranging background in complex corporate and regulatory reporting projects that consistently improved operational effectiveness and efficiency. A team player and driven individual with a strong work ethic and an excellent ability to focus, prioritize and handle multiple assignments. Fluent in Spanish.
CORE COMPETENCIES INCLUDE:
- SQL Server Administration
- SSRS Corporate Reporting
- Business Intelligence
- Integration Services SSIS-ETL
- T-SQL dev and automation
- Tuning and optimization
PROFESSIONAL EXPERIENCE:
Confidential, Deerfield Beach
Database Developer - DBA
Environment: SQL Server Visual Studio 2015 - Team Foundation Server - C# - SSRS - SSIS - Quest Spotlight
Responsibilities:
- Code and maintain highly complex and challenging reports for finance, audit, regulatory agencies, and statistical data contributions.
- Provide development support for data access, data analysis, ETL processes, reporting, database level programming, and performance tuning.
- Evaluate strategic goals for database development in conjunction with end users, managers, and clients to create functional specifications for database applications.
- Follow best practices to design all stored procedures, including full responsibility for schemas and how data is populated.
- Diagnose and resolve database access and performance issues with the production team to plan and implement capacity and resource expansion to ensure scalability of company databases.
Confidential, Ft. Lauderdale
DBA - Global Information Systems
Environment: SQL Server 2008/2012 - Oracle 9-11i - SAP - Excel VBA - .Net
Responsibilities:
- Executed all activities associated with DBA and project lead, completing over 12 software projects from requirements analysis to delivery and support.
- Coordinated with international IT team and business users to enhance, maintain, and monitor finance and sales applications encompassing Oracle enterprise and SQL Server environments.
- Created and kept documentation for database processes, built and optimized SQL queries used for direct back-end reporting from global enterprise applications.
Confidential, Ft. Lauderdale
SQL Server Production DBA
Environment: SQL Server 2008 - MySQL 5.5 (Oracle license) - Rackspace
Responsibilities:
- Sole DBA managing 200+ SQL server deployments at various ER sites throughout 12 states.
- Redesigned maintenance plans deploying enhanced t-SQL scripts to perform backups/restores, monitored SQL extended events, and optimized SSIS packages.
- Performance-tuned disk utilization, SQL file locations, and developed code for automated product deployments.
Confidential, Ft. Lauderdale
SQL Server Developer
Environment: SQL Server Business Objects XI - Tomcat - Crystal Reports XI - SSIS
Responsibilities:
- Successfully delivered, under tight deadlines a Business Intelligence-DW project encompassing SQL Server 2005, Sybase AS, Business Objects XI R3, and ETL-SSIS packages including installation, development, and deployment.
Confidential, Ft. Lauderdale
SQL Data Base Administrator
Environment: SQL Server Business Objects XI - Crystal Reports XI - SSIS - SSRS
Responsibilities:
- Managed business-critical reporting systems in a SQL Server environment using Crystal Reports, MS-Access, and advanced Excel analytic models to deliver timely and advanced reports to the VP Finance.
- Rewrote t-SQL queries improve execution time and optimize resources for company ASP-based reporting application.