TECHNICAL SKILLS

• Database design, modeling, & maintenance using Oracle & SQL Server. Object creation (tables, views, triggers,, functions, stored procedures, packages) using PL/SQL, T - SQL, SQL.
• Microsoft SQL Server Integrated Services (SSIS) and DTS, Talend & shell scripting in several languages on Linux, Unix, AIX & Windows. Oracle Forms & Reports, SQL Server Reporting Services (SSRS)
• Big Data (multi-terabyte) ETL & report generation, Data Warehousing, OLTP & OLAP, & DSS application development.
• Data governance, ineage, cataloging, and access security. Some experience in Java & J2EE.
• Oracle 7.x through 19c with emphasis on RAC implementations. MS SQL Server 6.5 through 2019, clustering & high availability (Always On).
• Informix 7.x through 11.X. Some DB2, MySQL & Postgres.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Database Engineer for a leading pediatric healthcare provider.
• Administrator for Clarity and Caboodle (Epic Healthcare Systems).
• Develop, implement, and improve existing code for data ETL (SSIS and shell scripting), data analysis, encryption/obfuscation, security auditing, and performance improvement.
• Assist Enterprise Architects, in the role of Data and Database Architect, with designing systems to integrate various data sources into a single reporting source.
• Building new High Availability solutions utilizing various technologies.
• Design, develop, modify, test, and implement shell scripts (Perl, Borne and Korn), stored procedures (PL/SQL, T/SQL), packages, functions, and queries for database-driven applications.
• Design logical and physical database models for test and production MS SQL & Oracle environments.
• Mentoring junior DBAs & training developers on database concepts and development using SQL.
• Designing, developing and administering automated processes to populate customer-specific data marts and operational data stores used by various internal departments.
• Perform capacity planning and space management.
• Migration, performance tuning, and replication, security, and backup/disaster recovery.
• Install, configure, and upgrade database servers.

Confidential

Senior Database Architect /Developer

Responsibilities:

• Database Architect for company providing Bill Pay, Cash Management & Internet Banking software, hosting, and consulting services to the banking industry and large corporations.
• Develop, implement, and improve existing code for data ETL (SSIS and shell scripting), data analysis, encryption/obfuscation, security auditing, and performance improvement.
• Designing, Developing and Administering database-driven applications used for automated bill pay & wire transfers between banks, large corporations, and our data centers.
• Design, develop, modify, test, and implement shell scripts (Perl, Borne and Korn), stored procedures (PL/SQL, T/SQL), packages, functions, and queries for database-driven applications.
• Develop, implement, and improve existing code for data ETL, data analysis, encryption/obfuscation, security auditing, and performance improvement.
• Design logical and physical database models for test and production MS SQL & Oracle environments.
• Mentoring junior DBAs & training developers on database concepts and development using SQL.
• Designing, developing and administering automated processes to populate customer-specific data marts and operational data stores used for CRM and Billing report generation.
• Automating maintenance and monitoring tasks.
• Perform capacity planning and space management.
• Migration, performance tuning, and replication, security, and backup/disaster recovery.
• Install, configure, and upgrade database servers.

Confidential

Senior Database Architect /Developer / Administrator

Responsibilities:

• Database Architect, Developer & Administrator for company providing print and electronic data for the airline, hotel, & travel industries.
• Design logical and physical database models for test and production MS SQL & Oracle environments.
• Develop, implement, and improve existing code for data ETL (SSIS and shell scripting), data analysis, encryption/obfuscation, security auditing, and performance improvement.
• Redesigning database and application to provide better performance and scalability, both horizontally and vertically.
• Manage contract developers and provide guidance on business logic, and workflow. Review deliverables and perform progress assessments.
• Manage Oracle Forms development and database support teams.
• Author documentation for product development designs, SOP (standard operating procedure) documents for disaster recovery and problem resolution. Provide as-needed support for existing applications.
• Author RFPs (Requests for Proposal) for projects requiring outsourced or contract labor and negotiate contracts based on the company’s needs, expectations and budget.
• Perform and supervise database upgrades for Oracle & MS SQL Server rdbms.
• Design, develop, modify, test, and implement SSIS projects.
• Administer Oracle & Microsoft SQL Server production and test databases, including migration, performance tuning, and replication, security, and backup/disaster recovery. Install, configure, and upgrade database servers.
• Create database instances and objects (stored procedures, views, functions, triggers, sequences).
• Administered database security; Install database products. Interact with and assist system administrator to provide a compatible and effective database environment.
• Perform capacity planning and space management. Monitor databases on daily basis and troubleshoot all database problems.
• Design logical and physical database models for test and production environments.
• Manager of Oracle Development Team. Perform code reviews of all SQL. Responsible for work assignments, performance reviews and ensuring the team adheres to company’s training standards.
• Authoring documentation for data governance, lineage, access, and cataloging (data dictionaries) based on company standards and industry compliance rules.

Confidential

Senior Database Architect /Developer / Administrator

Responsibilities:

• Database Architect & Administrator for company providing Bill Pay, Cash Management & Internet Banking software, hosting, and consulting services to the banking industry and large corporations.
• Designing, Developing and Administering database-driven applications used for automated bill pay & wire transfers between banks, large corporations, and our data centers.
• Develop, implement, and improve existing code for data ETL (SSIS and shell scripting), data analysis, encryption/obfuscation, security auditing, and performance improvement.
• Design, develop, modify, test, and implement shell scripts (Perl, Borne and Korn), stored procedures (PL/SQL, T/SQL), packages, functions, and queries for database-driven applications.
• Design logical and physical database models for test and production Informix, MS SQL & Oracle environments.
• Mentoring junior DBAs & training developers on database concepts and development using SQL.
• Designing, developing and administering automated processes to populate customer-specific data marts and operational data stores used for CRM and Billing report generation.
• Automating daily maintenance and monitoring tasks.
• Administer and update databases for internal and client Internet sites. Administer database security; Install database products. Interact with and assist system administrators to provide a compatible and effective database environment.
• Perform capacity planning and space management.
• Monitor databases on daily basis and troubleshoot all database problems
• Migration, performance tuning, and replication, security, and backup/disaster recovery.
• Install, configure, and upgrade database servers.