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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship