Systems Architect/ Software Engineer, DBA Resume

SUMMARY

Systems Architect supporting a range of software systems and databases serving Verizon’s sales, marketing and billing business units. Responsible for teh underlying architecture of a group of applications, and for overseeing teh work being done by any other developers, working on an agile release schedule. Maintain a set of highly available Oracle 11g and SQL Server 2012 databases. Design OLTP transactional and Analytical Star - Schema databases. An eye out for security and compliance.

Interact wif business stakeholders to understand, document and support users. Always customer-focused, approachable, and responsive. Automate data interchange between complex applications. Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Technical Tools and Environment: AWS EC2, Redshift, PCF, Automation Anywhere, Oracle Database 11g, Oracle RAC, Oracle Active DataGuard, Oracle RMAN, Oracle Enterprise Manager, Oracle OBIEE 11g, Oracle Weblogic, C#, ASP .NET, JavaScript, JQuery, VB, VB .NET, Red Hat Linux, Sun Solaris 2.6, MS SQL Server 2012, Korn Shell scripting, Python.

PROFESSIONAL EXPERIENCE

Confidential

Systems Architect/ Software Engineer, DBA

Responsibilities:

Lead application redesign to build cloud native services utilizing AWS.
Lead end-to-end system architectural design and development efforts for Verizon FiOS MDU Sales Group. Implement efficiencies, making systems, and applications more scalable, and user friendly.
Plan and develop long-range objectives and milestones for IT projects that involve substantive, mission-oriented, and financial management systems.
Data Modeling for Sales transactional (OLTP) database, and Verizon FiOS Sales Metrics Star Schema Data Warehouse. Warehouse provides easy and timely reporting of latest metrics to Account Managers, Regional Marketing Managers, and Verizon Executives.
Implemented Sales Metrics Star Schema ETL/ELT processes for FiOS Sales Metrics Data warehouse.
Build and maintain database stored procedures used for Application DML updates, code supporting data loads, and building summaries for dashboards.
Design and build Disaster recovery solutions for our applications at all layers.
Setup backup and Recovery plans, scripts and managed data retention policies incompliance wif Verizon CPNI-810 mandate.
Gather requirements and understand teh data needs of internal customers. Metrics development for sales and billing results for telecommunications services. Write key sections of business requirements documents to direct system development. Present new ideas to stakeholders, work on producing Proof Of Concept models
Implement latest database security and encryption features to comply wif Verizon’s CPI-810 measures, protecting highly confidential data. Review application logic and processes to comply wif teh same CPI-810 measures.
Advanced SQL coding skills. Write extensive SQL queries for summary development and to satisfy ad hoc queries.
Migrate databases between versions, using Oracle data pump export/import, DBUA and database upgrade in place using scripts.
Preparation and presentation of process and data flow diagrams to aid development efforts to support new and changing business requirements.
Perform Oracle performance tuning including reviewing access path and proper indexing, assist developers wif query development.
Created central repository for all critical database jobs, wif advanced logging and alert notifications.
Define data interchange for Verizon initiatives using narratives and system diagrams. Work wif IT architects responsible for other domains and project leads to define source, transformation, and presentation of data.
Presentations to upper management on development initiatives, design decisions, outages, and resolution.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship