We provide IT Staff Augmentation Services!

Db Manager Resume

SUMMARY

Goal - oriented and results driven IT Professional. I am dedicated to cutting cost through innovation and technology. I have been successful in my career in building motivated and dynamic teams.

SUMMARY OF QUALIFICATIONS:

  • Management ( Operations )
  • Budgeting
  • Project Management
  • Waterfall Methodology
  • Agile (SCRUM)
  • SQL Server
  • SSIS
  • SSAS
  • SSRS
  • Service Broker
  • Power BI
  • Master Data Services (MDS)
  • Always On
  • Replication
  • Log shipping
  • Change Data Capture
  • Powershell
  • Postgres
  • Progress
  • Sybase
  • ERP
  • Sage MAS 500
  • Sage MAS 90
  • Sage Saleslogix
  • Epicor 9
  • MS Dynamics - GP ( 8.0, 9.0)
  • Database Architect
  • Warehouse Design (Kimball, Inmon)
  • Extraction Transform Load (ETL)

PROFESSIONAL EXPERIENCE:

Confidential

DB Manager

Responsibilities:

  • Managed a team of 14 developers 2 supervisors
  • Oversee day to day operations of Data Farm
  • Implemented Agile (SCRUM) to deliver
  • Authored new policies Database management
  • Manage budgets
  • Payroll
  • Software
  • Infrastructure
  • Mange software vendors Conduct in-depth technical analysis of all DB systems, including the governance framework, architecture, and disaster recovery and business continuity.
  • I delivered gap analysis and recommendations, attaining higher up time.
  • Manage import/export of EDI files

Confidential

BI/DBA/Integration Developer

Responsibilities:

  • This is a government contactor. I am limited in what I can post on my resume.

Confidential

BI Developer

Responsibilities:

  • Create Logical/Physical Models for warehouse design ( Kimball Method )
  • Gathered and Documented warehouse design
  • Project Charter
  • Visio Diagrams
  • Requirement documents
  • Schema and data dictionary
  • Integrate Multiple sources into warehouse
  • Created backup architecture via powershell
  • Normalize all source data into unified schema
  • Managed Master Data Management (MDM) implementation
  • Created RFP Requirements
  • Managed the Q&A process from vendors
  • Created all user stories for Proof of Concept (POC)
  • Staged data for POC
  • Responsible for all communications between Stakeholders, Management and Implementation team

Confidential

Principal Data Architect

Responsibilities:

  • Create Logical/Physical Models for warehouse design ( Kimball Method )
  • Gathered and Documented warehouse design
  • Project Charter
  • Visio Diagrams
  • Requirement documents
  • Schema and data dictionary
  • Integrate Multiple sources into warehouse
  • Normalize all source data into unified schema
  • Managed Master Data Management (MDM) implementation
  • Created RFP Requirements
  • Managed the Q&A process from vendors
  • Created all user stories for Proof of Concept (POC)
  • Staged data for POC
  • Responsible for all communications between Stakeholders, Management and Implementation team

Confidential

Database Architect (Consultant)

Responsibilities:

  • Data Architect
  • Create Logical/Physical Models for warehouse design ( Kimball Method )
  • Gathered and Documented warehouse design
  • Project Charter
  • Visio Diagrams
  • Requirement documents
  • Schema and data dictionary
  • Integrate Multiple sources into warehouse
  • Normalize all source data into unified schema
  • Created SSIS package for ETL Process
  • Create suite of SSRS reports
  • Implemented SSAS
  • Tabular
  • OLAP
  • Created Portal for management of Data warehouse
  • Role assignments
  • ETL log information
  • Integrity Checks
  • Record counts
  • Item amount verifications
  • Implemented “Always On” cluster to multiple locations ( Read - Only)

Confidential

IT Manager \ Database Architect \ DBA

Responsibilities:

  • IT Manager
  • Managed development team of 7
  • Ran daily stand-ups (SCRUM)
  • Managed budgets
  • Software
  • Employee salaries
  • Consultants
  • Responsible for shaping IT direction
  • Responsible for communication between IT and management
  • Developed/Maintained Project Documents
  • Project Charters
  • Statement of Work
  • Meeting Minutes
  • Assumption List
  • Change Logs
  • Developer
  • Custom Stored Procedures
  • Service Broker integration
  • Custom Triggers
  • Custom SSIS packages
  • Importing / Exporting Data
  • Data manipulation
  • Processing Dimensions and Cubes
  • WMI integration
  • Web Service Integration
  • Custom Reports using SSRS
  • Custom Dashboard
  • Dynamic parameter driven reports
  • SSAS driven reports
  • SharePoint Integration
  • Architect
  • Designed OLTP website design
  • Designed Financial Data warehouse
  • Architectural Designs include
  • Hierarchical
  • 3rd Normal Form
  • Nested Set
  • 2nd Normal From (Data Warehouse)
  • Created backup scripts via Powershell
  • DBA
  • Manage 60 instance server environments. Databases sizes range from 20 gigs to 1.5 Terabytes
  • Implement Replication
  • Snapshot
  • Transactional
  • Perform database space management, including extent checks and extending database space as needed
  • Performed standard database operations including exports, imports, table restorations, and reorganizations appropriate for the support level
  • Performed database installs/upgrades
  • Performed database recoveries on production platforms
  • Ensure proper security policies and procedures are in place and enforce appropriately at the team and database environment levels
  • Provided leadership, mentoring, and technical assistance to junior team members
  • Performed comprehensive reviews of database environments and operations.
  • Provided thorough documentation, observations and recommendations according to DBA Team best practices
  • Created custom SSRS reports and SSIS packages.
  • Designed Maintenance system for 50 server instances
  • Capture pre/post statistics
  • Capture growth rates
  • Consolidated Reporting System(SSRS)
  • Ability to schedule different maintenance functions
  • WMI integration to capture problem queries. If CPU or Memory rises above a certain threshold…jobs will capture queries that are currently running.
  • Build scripts that include:
  • Database Creation( based on the Model db )
  • Maintenance Jobs
  • Integration with Central Management
  • Implement “Always on” cluster to multiple locations
  • ERP Implementation
  • Project Lead for Epicor 9 (E9) rollout
  • Responsible for Setup
  • Financials
  • Material Management
  • Order Management
  • Designed Project Charter
  • Designed Workflows for Modules
  • Created / Maintained project plans

Confidential, Culver City, CA

Database Architect \ DBA

Responsibilities:

  • Developer
  • Custom Stored Procedures
  • Service Broker integration
  • Custom Triggers
  • Custom SSIS packages
  • Importing / Exporting Data
  • Data manipulation
  • Processing Dimensions and Cubes
  • WMI integration
  • Web Service Integration
  • Custom Reports using SSRS
  • Custom Dashboard
  • Dynamic parameter driven reports
  • SSAS driven reports
  • SharePoint Integration
  • Architect
  • Designed Maintenance system for 300 server instances
  • Capture pre/post statistics
  • Capture growth rates
  • Consolidated Reporting System(SSRS)
  • Ability to schedule different maintenance functions
  • WMI integration to capture problem queries. If CPU or Memory rises above a certain threshold…jobs will capture queries that are currently running.
  • Build scripts that include:
  • Database Creation( based on the Model db )
  • Maintenance Jobs
  • Integration with Central Management
  • DBA
  • Perform database space management, including extent checks and extending database space as needed
  • Performed standard database operations including exports, imports, table restorations, and reorganizations appropriate for the support level
  • Performed database installs/upgrades
  • Performed database recoveries on production platforms
  • Ensure proper security policies and procedures are in place and enforce appropriately at the team and database environment levels
  • Provided leadership, mentoring, and technical assistance to junior team members
  • Performed comprehensive reviews of database environments and operations.
  • Provided thorough documentation, observations and recommendations according to DBA Team best practices
  • Created custom SSRS reports and SSIS packages.
  • Setup Database Mirroring and Log Shipping

Confidential, Culver City, CA

DB Manager \ Database Architect \ DBA

Responsibilities:

  • Managed 4 DBA’s (2 Offshore)
  • Identify Problem Queries and divide among the DB team
  • Managed budgets
  • Software
  • Employee salaries
  • Consultants
  • Responsible for shaping IT direction
  • Responsible for communication between IT and management
  • Created architecture for new software products
  • Implemented New SAN Solution (Clarion CX 380)
  • Upgraded Servers from 2000 to 2005 (64 bit)
  • Lead Administrator of a 20 terabyte database.
  • Upgraded all database from 32 bit 2000 to 64 bit 2005
  • Designed the entire maintenance infrastructure for OLTP environment.
  • Create backups strategies for the OLTP
  • Created and Maintained archiving process for OLTP
  • Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
  • Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
  • Installed and maintained infrastructure for BizTalk
  • Created Rules using BizTalk
  • Maintained BAM
  • Installed, configured, and maintained SharePoint Server 2007
  • Performed performance audits
  • Install/Configure SQL Server 2005
  • SQL Server Analysis Services
  • SQL Reporting Services
  • SQL Integration Services
  • SQL Replication
  • Transactional
  • Snapshot
  • Create/Maintained modeling for Physical and Logical design
  • Maintained architecture using ER Studio (Embarcadero Suite)
  • Practice SDLC principals

Data Warehouse Administrator \ Developer

Confidential

Responsibilities:

  • Created Custom ETL process for warehouse.
  • Combined Several databases into one warehouse
  • Create reports using Crystal Reports and SQL Reporting services
  • Created and Designed OLAP Cubes

Project Manager

Confidential

Responsibilities:

  • Trained in Agile Project Management Methodology (SCRUM)
  • Trained in Waterfall Project Management Methodology
  • Managed Data warehouse Project
  • Designing Specifications
  • Pre/Post Documentation for any changes to the system
  • Lead Daily Stand-ups (SCRUM)
  • Maintained Documentation
  • Provide budget forecasting for Capital Expenditures
  • Implemented 5 node virtual cluster
  • All nodes active
  • Live migration of images
  • Priority Failover

Confidential, Los Angeles, CA

Database Architect

Responsibilities:

  • Lead Administrator of a 40 terabyte database.
  • Designed the entire maintenance infrastructure for OLTP environment.
  • Manage Replication of database across Several servers in 3 data centers
  • Install/Configure SQL Server
  • Create Data warehouse(s) for OLTP.
  • Created Custom ETL process for warehouse.
  • Create backups strategies for the OLTP
  • Performance tuning for system
  • Write Custom ANSI - 92 Standard SQL queries
  • Create reporting customizations in Crystal Reports and SQL Reporting services
  • Pre/Post Documentation for any changes to the system
  • Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
  • Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects

Confidential, Los Angeles, CA

Senior Technology Consultant

Responsibilities:

  • Installed ERP software applications (MAS 500, Great Plains, Solomon).
  • Provide technical support and training to existing ERP clients and upgrade systems to latest software versions
  • Migrate data from previous system to new ERP system
  • Install/Configure SQL Server
  • Create Data warehouse(s) for ERP applications.
  • Created Custom ETL process for warehouse.
  • Create backups strategies for ERP Application
  • Run SQL profiler to identify potential bottlenecks
  • Create hardware specification for ERP application
  • Write Custom ANSI - 92 Standard SQL queries
  • Create reporting customizations in Crystal Reports
  • Screen Customizations using ERP customization tools
  • Post implementation support for client(s). Including maintenance, debugging, and optimization
  • Manage database(s) processes with SQL Server
  • Create data fixes for corrupted data in MAS 500 via SQL Server
  • Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
  • Trouble shoot application process
  • Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
  • Optimize performance for Stored Procedures with SQL Server. Insuring queries are using the best query plan
  • Created Custom ETL process for warehouse.
  • Combined Several databases into one warehouse
  • Create reports using Crystal Reports and SQL Reporting services
  • Created and Designed OLAP Cubes
  • Assist design team with new features

Confidential, Irvine, CA

Implementation Consultant\Support Engineer

Responsibilities:

  • Installed ERP software applications (MAS 500). MAS 500 contains Financials, Distribution, and Manufacturing
  • Provide technical support and training to existing ERP clients and upgrade systems to latest software versions
  • Migrate data from previous system to new ERP system
  • Install/Configure SQL Server
  • Create backups strategies for ERP Application
  • Run SQL profiler to identify potential bottlenecks
  • Create hardware specification for ERP application
  • Write Custom ANSI - 92 Standard SQL queries
  • Create reporting customizations in Crystal Reports
  • Screen Customizations using ERP customization tools
  • Post implementation support for client(s). Including maintenance, debugging, and optimization
  • Manage database(s) processes with SQL Server
  • Create data fixes for corrupted data in MAS 500 via SQL Server
  • Design and trouble-shoot custom Stored Procedures, Triggers, Functions with SQL Server
  • Trouble shoot application process
  • Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects
  • Optimize performance for Stored Procedures with SQL Server. Insuring queries are using the best query plan
  • Assist design team with new features

Confidential

Database Developer/DBA

Responsibilities:

  • Manage database(s) processes with SQL Server
  • Managed replication process via Tsunami software
  • Design\Trouble shoot custom Stored Procedures, Triggers with SQL Server
  • Implemented new database security model. Includes implementing windows security into database architecture, changing database port(s), and restricting access to database objects.
  • Optimizing performance for Stored Procedures using SQL Server. Insuring queries are using proper indexes.
  • Use database utilities to perform analysis to determine bottlenecks.
  • Upgraded SQL Server from 6.5 to 2000
  • Created custom Stored Procedures

Hire Now