We provide IT Staff Augmentation Services!

Database Developer/administrator Resume

SUMMARY

  • Highly skilled and accomplished Information Technologies Professional with outstanding Management, Consulting, Business Intelligence, Database Administration, and Development experience delivering world class business solutions for a broad range of industries.
  • Exceptional technology foundation and abilities spanning business and systems analysis, enterprise resource planning (ERP), electronic data interchange (EDI), applications development, systems administration, problems resolution, disaster recovery, and support. Excellent leadership, organizational, and team working skills and proven success in operations and project management as well as business process reengineering.
  • Cross - industry experience in Manufacturing, Financials, Distribution/Logistics, Transportation, Insurance, Utilities, Healthcare, Hospitality, Education/Training, and Technology/Software Development

TECHNICAL SKILLS

Cloud Computing: Amazon Web Services (AWS), Microsoft Azure

Databases: Microsoft SQL Server (2017, 2016, 2014, 2012), MongoDB, Progress, DB2, Paradox, Microsoft Access, Oracle

Programming/Development: T-SQL, SSIS, SSAS, SSRS, BitBucket, GitHub, Tortise, Apache Subversion (SVN), Visual Studio, Crystal Reports, Cognos, XML, Visual Basic, Java, RPG(Free, ILE, IV, III,II), COBOL, CL, Progress

Software: Confidential (LMS), Jira, Confluence, Izenda, RedGate, Idera, Pro2SQL, Tidal (Enterprise Scheduling Software), DTS xChange, Reliance(ETQ), Genesis(ESHA), Avantis(Invensys), Infinity QS, Active Directory, IIS, Client Access, CL, JD Edwards (EnterpriseOne, OneWorld, World), Sales Partner Systems, DBU, Hawkeye, DataTech, Infinium (Software 2000), GENIUS, Pro-Cede, Chempax, SAP, ORCOM, Predictive Dialer (Mosaix), Lotus Notes, MS-Office, Implementer (MKS), Siebel, and BizConnect (Inovis), Gentran (EDI).

Operating Systems: Windows Server, Windows (10, 8, 7, Vista, 2000, XP, NT), OS/400.

PROFESSIONAL EXPERIENCE

Confidential

Database Developer/Administrator

Responsibilities:

  • Installed, configured, and migrated SQL Server, SQL Server Integration Services ( SSIS ), Analysis services ( SSAS ), and Reporting services ( SSRS ).
  • Established and coordinated with .Net development project teams internationally to develop database architectures, best practices, coding standards, code review and quality assurance policies and procedures .
  • Monitored SQL Performance analyzing code, Indexes and providing recommendations for improvements.
  • Designed, Architected, and Updated legacy Learning Management Software Schema to leverage SaaS Multi-tenant Cloud database implementation across SQL Server for about 156 Clients and 29TB resulting in flexible design to deliver features more quickly.
  • Refactored and Updated T-SQL coding (Stored Procedures, Functions, Triggers and Views), SQL Server Integration Services (SSIS), ETL and SQL Server Reporting Services (SSRS) increasing performance.
  • Designed Visual Studio Database Project to deliver features and schema changes from a sparsely quarterly to regular weekly continuous deployments increasing smaller code changes, faster release rate and customer satisfaction in alignment with Agile methodologies.
  • Developed and scripted a process to implement audit and compliance for HIPPA, GDPR, SOX, PCI using SQL Server Change Data Capture.
  • Knowledge in using Izenda, JIRA, Confluence, Entity Framework, GitHub, BitBucket, and Amazon Web Services (AWS) Cloud environment.

Confidential

Consultant

Responsibilities:

  • Independent Consultant on Business Intelligence, SQL Data Administration and Development.
  • Supporting daily Qlikview Business Intelligence and SQL Server 2008 R2
  • Implementation of SQL 2008 R2 including configuration, security, backup/recovery, SSIS and SSRS Reporting Services.
  • Developed and designed reports on SQL 2008 SSRS with proficiency in using Report Designer as well as Report Builder.
  • Conducted SQL audits and design recommendations for prospective clients.
  • Monitored SQL Performance working with Redgate, Idera, PERFMON and SQL Profiler.

Confidential

Senior Business Intelligence/Database Administrator(DBA)

Responsibilities:

  • Refactored and updated ETL and Datawarehouse processes for best performance and proper dependency.
  • Experience in ELT/ETL high volume/large scale datasets from sources like Progress, SQL, and Flat files.
  • Designed maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
  • Monitored database size and disk space in Production, Staging & Development environments.
  • Cognos SQL statements using Execution Plan in T-SQL for better performance.
  • Upgraded Cognos Data Manager 8.1 to 8.4.1 and Cognos 8.3 to 8.4.1.
  • Responsible for ETL and production environment issues.
  • Knowledge in using Team Foundations.
  • Implementation and Migration ETL processes to Cisco Tidal Enterprise Scheduling software.

Confidential

Senior Database Administrator (DBA)

Responsibilities:

  • Served as Database Administrator or project lead in the completion of 50+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
  • Created database recovery, security, performance tuning, and maintenance on SQL 2000, SQL 2005 systems.
  • Reengineered business and systems processes in preparation for an ERP selections and implementation.
  • Developed solutions to leverage ETL tools and identify opportunities for process improvements in SSIS, Cognos Framework models for Business Intelligence/Data warehouse.
  • Implementation of MS SQL Server 2005 Business Intelligence (BI) tools, SSRS, SSAS.
  • Developed, maintained, and support of Crystal Reports.
  • Converted DTS packages from SQL 2000 to SQL 2005 SSIS using DTSxChange product.
  • Responsible for Database Administration (DBA) of MS SQL 2005, 2000 environment with approximately 100 databases throughout the organization.
  • Administration, Support and development of Cognos BI/EP 8 and Cognos 7 environments.
  • Consolidating SQL Server across the organization for improved business continuity, performance, security and management.
  • Reengineered business and systems processes in preparation for an ERP selections and implementation.
  • Managed lead Quality Assurance project for implementation of Reliance (ETQ) in SQL Server environment allowing company to pass certification for British Retail Consortium (BRC) Compliancy for Food Safety.

Hire Now