DBA\BI Developer Resume Crystal City, VA - Hire IT People

SUMMARY:

5 plus experience of progressive SQL Server Administration
Experience with installation of SQL Server 2005, 2008, 2008R2 and 2012
Experience in Data migration and upgrading of databases
Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back - up/recovery, running Database Consistency Checks using DBCC.
Experience in Microsoft Business Intelligence tools SSIS, SSRS and SSAS
Expert in designing and implementing Tableau and SSRS reports
Designed and deployed ETL Solutions in SSIS and created SQL Server Agent Jobs
Extensive experience in Performance Tuning(PTO), and Troubleshooting procedures
Experience working with Healthcare Claims Data
Experienced working in virtual environment
Working closely with management and application development team and users on database solutions to resolve business problems
Self-motivated, creative team player with effective communication skills
Ability to work in fast-paced environment
Ability to adapt to changing environments, able to pick up new things very quickly

TECHNICAL SKILLS:

Tools: Windows Server 2008, 2005, 2003, Windows XP, Windows 7, T-SQL, Microsoft Visual Basic, Microsoft Office, T-SQL

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Data Tools, Microsoft Access, Excel, Tableau Customer Relationship Management Tools - CRM like SAP and Salesforce, Index Tuning Wizard, SQLCMD

Third Party Tools: Spotlight, Red Gates, and Toad for SQL

PROFESSIONAL EXPERIENCE:

Confidential, Crystal City, VA

DBA\BI Developer

Responsibilities:

Performed maintenance of Databases, Tables, Views, Triggers, Stored Procedures, Schemas and Indexes
Designed and developed ETL business solutions using SSIS Packages, Stored Procedures and Shell Scripting
Installed, configured and administered SSIS, Reporting Services (SSRS), and Analysis Services (SSAS)
Designed and implemented Tableau dashboards and SSRS reports
Developed SSIS packages to perform nightly jobs
Developed Stored Procedures, Advanced Queries, Triggers, Views, and Indexes
Developed PowerShell scripts and ETL\SSIS Packages for data import
Developed and communicated best practices for report development
Supported the analysis, design, enhancement, and maintenance of BI solutions and dashboards.
Identified and documented BI requirements from client and defined BI strategies for implementation
Installed and administered SQL server 2008R2/ 2012/ 2014
Managed deployment of new processes and scripts to Production Environment. Worked on full SDLC process.
Designed and implemented comprehensive backup plan and disaster recovery strategies
Monitored and planned for performance using SQL Profiler, SQL Performance Monitor, CPU and Disk space requirements
Maintained the integrity, availability, and recoverability of all production data systems
Optimized databases by creating various clustered, non-clustered indexes and indexed views
Worked with Agile teams for requirement gathering and customer engagement
Presented key project updates, issues and resolutions to IT management and customers

Confidential, Silver Spring, MD

DBA\Developer

Responsibilities:

Designed and implemented comprehensive backup plan and disaster recovery strategies
Maintain the integrity, availability, and recoverability of all production data systems
Performed point in time recovery
Installed, Configured, and Administered Replications in SQL Server 2012, 2008 and 2005
Installed, Configured, and Administered Database Mirroring in SQL Server 2008 R2
Configured log shipping for reporting purpose
Applied SP (Service Packs) on SQL Server 2005, 2008, 2008R2
Upgraded databases from SQL Server 2000 to 2005, 2005 to 2008 R2 and 2008R2 to 2012
Performed maintenance of Databases, Tables, views, triggers, stored procedures, schemas and indexes
Developed SSIS packages to perform nightly jobs
Created logins and users, created roles and managed user permissions
Configured database mail and SQL Server Agent
Created SQL Server Event and Performance Condition Alerts, operators and Proxies
Created and maintained scheduled jobs and maintenance plans to automate different database related activities including backup, monitoring database health, disk space, backup verification
Optimized the database by creating various clustered, non-clustered indexes and indexed views, optimized query
Performance Monitoring using SQL Profiler, Performance Monitor, planning for CPU and Disk space requirements
Identified I/O, CPU bottlenecks
Reviewed and Tested SQL Scripts from the development team before releasing them into Production Environment.

We provide IT Staff Augmentation Services!

Dba\bi Developer Resume

Crystal City, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship