We provide IT Staff Augmentation Services!

Dba / Data Architect / System Architect Resume

SUMMARY:

Result oriented technical manager with over 15 years of experience in Software Development, Data Architecture, Server Management, Data Warehousing, DBA and Quality Assurance. I will Organize, Optimize and Streamline any process in your organization.

TECHNICAL SKILLS:

Operating Systems: MS Windows/Server, Linux, Centos, Red Hat, HPUX

Database Systems: MS SQL Server 2014, 2012, 2008 R2, MySQL

Web Development: MS Internet Information Services (IIS), Apache HTTP Server

BI and ETL: MS BI (SSIS, SSRS, SSAS), Talend, Informatica

Programming: PHP, SQL, Java, C, C++, Visual Basic, PowerShell, Pearl

Data Modeling: ERwin, MS SQL Server Management Studio

LAN/WAN: Ethernet

Virtualization: VMWare

PROFESSIONAL EXPERIENCE:

Confidential

DBA / Data Architect / System Architect

Responsibilities:

  • As a consultant provided the following services to various clients
  • Liaison between Stake holders and IT
  • Design new Architecture from concept to implementation
  • Infrastructure design and recommendations
  • Sever selection (Internal vs Cloud)
  • Data Modeling and Data Integrity
  • Data Warehousing
  • OLTP, OLAP
  • ETL (Extraction, Transformation and Loading)
  • Create Logical and Physical Data Model
  • Maintain and Generate new Databases
  • Reverse engineer existing Databases
  • Document data flow, process and procedures
  • Suggest improvements
  • Disaster & Recovery Plan
  • Consult with developers who seek advice for best practices
  • Implement best practices
  • Databases Security and Maintenance
  • Review developer’s code and suggest improvements
  • Ensure availability and performance of all/Production DBS
  • Manage Database Support & Maintenance
  • Load Balancing, Performance tuning and Replication
  • Private and hybrid Database Solutions
  • Maintain and Patch Op Sys & Databases as Needed
  • Evaluate Project feasibility.
  • Infrastructure Architecture and Design, Data Architecture, Data Modeling, reverse engineering, MS BI Database Design, Process Automation and building new statistical data reports.
  • Installation and maintenance of MS SQL Server 2012, 2014. Data Modeling using SSMS, Reverse engineering existing systems without documentation, Automating manual processes done in SSIS and generate reports in SSRS.
  • Build New CRM for SEO on Windows Server 2008, 2012
  • MS SQL Server 2008 R2 (SSIS, SSRS, SSAS), MS SQL Server Management Studio, Data Modeling using ERwin.
  • Building a new CRM project for Stock Market Industry in LAMP (Linux, Apache, PHP, MySql) and ERwin.
  • Infrastructure design, Server evaluation and recommendation for a multimedia web application capable of handling up to 1,000,000 concurrent users, OLTP Design.

Confidential

Data Architect / Project Manager

Responsibilities:

  • Sever management & Configuration
  • High availability
  • Replication Server
  • OLTP and DRP (Disaster Recovery Plan)
  • Data Modeling (Logical and Physical)
  • Performance Tuning
  • Front - end and Back-end process design
  • ETL & DBS Optimization

Confidential

Data Architect and DBA

Responsibilities:

  • Set up plan, Began Re-Design of existing OLTP system and Data Architecture
  • Design New Data Model using ERwin to improve Data Accessibility and Scalability
  • Streamlining Servers, Databases, and all DBA related tasks
  • Managing 8 Servers and more than 10 Databases (PROD, QA, DEV)
  • Managing MS Windows 2008/ SQL Server 2008
  • Plan to save more than $300,000 by migrating from Microsoft platform to LAMP

Confidential

Project Manager/DBA

Responsibilities:

  • Managed & led team of DBAs across 5 different departments
  • Installing more than 50 Servers/ 200 Databases/ 30 Applications
  • Managed HPUX/Oracle, HPUX/Sybase & NT/MS SQL Server
  • Managed Development, Test and Production Servers 24/7
  • Provided Data Modeling, Performance Tuning, High Availability, OLTP Design, Development, QA, DRP, Replication Server and safe Daily Backup services

Confidential

Instructor and Senior DBA

Responsibilities:

  • Taught one year program of Data modeling (Erwin) to IT team in Confidential Japan
  • Established Standardized Server Management similar to what was developed in USA

Confidentia

Senior DBA and team lead

Responsibilities:

  • Designed the first Database for Build To Order system (BTO) in MS SQL Server
  • Later on Migrated the Database to Sybase and few years later to Oracle
  • Developed and migrated OLTP applications to the latest version of MS SQL Server
  • Developed a remote monitoring application for Confidential & Confidential via Unix/Sybase SQL Server
  • Designed an Application (price quoting system) in MS SQL Server & Visual Basic
  • Trained DBA teams in US, Japan, Korea, Philippines and Malaysia
  • Designed & implemented Standards for back-end processes across Confidential sites in North America and Asia Pacific regions

Hire Now