Senior Sql Dba/bi Systems Architect Resume
New, JerseY
SUMMARY
- Data Engineer experienced in all aspects of project management and full cycle application/decision support systems development, with very strong hands - on technical skill set and problem-solving ability. Self-starter with more than fifteen years proven track record of achievements in quality improvement and development of various customized solutions.
- Excellent team player, who can successfully manage multiple projects simultaneously and deliver exceptional results. Always strives to learn new technology in order to boost productivity and customer satisfaction.
- Highly experienced in planning and implementing customized high-availability and disaster recovery solutions using latest MS SQL Server technology, such as Always On Availability groups
- More than fifteen years experience handling, implementing and supporting large scale data warehousing projects
- More than ten years experience in implementation of mid to large scale customized ETL solutions utilizing SSIS and third party tools
- In depth knowledge of MS SQL Server performance tuning and security implementation
- Able to manage multiple software and data deployment projects simultaneously
- Hands-on experience with SQL standards, T-SQL/PL SQL
- In depth knowledge of computer hardware and software latest technologies
- Designed and implemented customized High Availability/Disaster Recovery solutions ( Confidential /VNAHG)
- Designed and successfully implemented home-grown data warehouse/marts solution integrating, cleansing and formatting data sourced from various databases, such as HCHB(SQL Server), NEXTGEN (SQL Server) Lawson (Oracle 10g/11g), Mediware Perioperative Solutions (SQL Server), Clinstar, PICIS Clinical System ( Confidential ), utilizing Erwin (R9.6)/ TOAD
- Designed and successfully implemented highly customized ETL solutions ( Confidential /VNAHG), utilizing MS SSIS
- Designed and successfully implemented BI/Decision support solutions utilizing Oracle 10g/11g, MS SQL Server 2012/2014, MS SSRS, Crystal Reports, Business Objects ( Confidential /VNAHG)
TECHNICAL SKILLS
Database Administration: MS SQL Server 2000/8/12/14/16 , Oracle 10g/11g
Data modelers: Erwin, TOAD
Project management tools: MS Excel, MS Access, MS Project, MS Visio
Decision Support/Data Presentation tools: Tableau, Crystal Reports, Business Objects
Systems/Databases: HCHB back-end, NEXTGEN Back-end, UltiPro back-end, PICIS database, Lawson database, Clinstar, Eagle database, CliniCis database
Programming languages: SQL, T-SQL, PL SQL, C++, Java, VB/C#.NET, ASP.NET, ASP/ASP script
PROFESSIONAL EXPERIENCE
Confidential, New Jersey
Senior SQL DBA/BI Systems architect
Responsibilities:
- Developed and implemented data backup, disaster recovery and “off-site” ETL solutions. Implemented data security and reliability strategies. in various data discovery, data mining and data presentation projects. Responsible for support, proper upgrade and administration of Tableau servers.
- Planned, developed and executed organization-wide data integration/BI projects. Developed and implemented databases, data collection systems, data analytic strategies with the main objective to optimize statistical efficiency and data quality. Identified, analyzed, and interpreted trends and patterns in complex data sets.
- Manage SQL Server/PostgreSQL proper deployment and upgrade procedures. Responsible for data security, integrity and database performance.
Confidential, New York
Senior DBA/Application Development lead
Responsibilities:
- Managed organization-wide clinical systems deployment, configuration and staff training. Developed and implemented various migration/data integration solutions for several clinical applications including Mediware Perioperative Solutions to PICIS data migration plan. Successfully concluded high performance/always-on/highly customized data warehousing/decision support solution for PICIS clinical system.
- Managed enterprise-wide custom Oracle/SQL Server database design projects. Developed technical requirements for hardware/networking/software high performance, cost effective projects, including SQL Server 2000 to SQL Server 2008 “no downtime” data migration strategy.
- Introduced new, highly effective approach to data disaster recovery, hardware hardware/networking configuration including data virtualization and cost-effective redundancy solutions.
Confidential, New York
DBA/Application Architect
Responsibilities:
- Data/Business/Systems Analysis
- Data Flow & Process Mapping
- Disaster Recovery Planning
- SQL Queries & Data Modeling
- Software Design/Implementation
- SQL Server administration
- Database Design & Management
- Technical Writing (Specs)
Confidential, New York
Programmer/Analyst
Responsibilities:
- Define user requirements
- Implement business rules
- Design multiple menu-driven screens
- Front-end coding (C++, MS Visual Basic)
- Program Oracle/SQL Server based back-end (Stored procedures, triggers and functions)