Computer Consultant Database Administrator
Resume:
John Nieblas
***********@*******.*** 323-***-****
PROFESSIONAL SUMMARY
•More than 15 years of diversified experience in Information Technology
•Multiple operating system experience, including Windows, Unix, Linux
•Experience in Disaster Recovery and Business Continuity Aws, Azure and On-Prem
•AWS Cloud Experience - EC2, RDS, Serverless Computing, Lambda
•AWS EBS, Volume Snapshot Deployment, S3 Buckets, Glacier
•AWS AMI, Control Tower, IAM, Groups. User, Role, Policies, Encryption (Rest & Transit)
•Aws Budget Experience - Reserved Instance Purchases and MSN Licensing Experience
•Aws Glue, Aws Data Brew, Aws Data Lakes, Aws Data Pipelines
•DataBricks Enterprise, Notebooks, Delta Lakehouse, APIs, Libraries
•Azure Cloud Ecosystem Experience
•Azure - Sql Server, Data-Warehouse, Data Factory, Data Studio, Synapse, Data Bricks, Data Lakes
•AOAG - WSFC, Replication, Db Mirroring, Active Directory, DSN
•Programming Languages 3GL - C, Visual C++, C #, Java, Python
•Programming Languages 4GL - Transact SQL, PL/SQL, Oracle Forms, and Oracle Developer
•SQL Server Database Versions - 2019,2017,2016, 2014,2012,2008R2,2008, 2005, 2000 7.0, 6.5,
•Oracle Databases Versions - 11i, 10g, 9i, 8i, 7.x and Oracle RDB
•Additional AWS Databases - PostgreSQL, MySQL, Aurora
•Security - Always Encrypted, TDE, PAM Implementation, Windows, Sql, Kerberos Auth
•Infrastructure as Code - Terraform, Ansible Play Books, Cloud Formation
•Additional Relational Databases - Sybase, Illustra, Access
•NoSQL Databases -Hadoop, HBase, Spark, MongoDB
•Scripting Languages - Python, PowerShell, JSON, Perl Script
•BI/Data Analytics Tools - Tableau, Alteryx, MS Excel Pivot tables, Business Objects, Aws EMR
•SharePoint - 2015, 2013, 2010, SharePoint Services
•Case Tools - Erwin, Data Architect, S-Designer, and Visio Professional
•Project Management Tools - MS Project, Asana, JIRA, Confluence, Pivotal Tracker, Rally
Methodologies - Agile, CMMI, Deloitte & Touché, Traditional Waterfall, Data-Mesh
PROFESSIONAL EXPERIENCE
Affinity Solutions New York, New York March 2022 - Present
AWS Enterprise Data Architect
•Architected DataBricks, SnowFlake, Redshift, Postgres deployment through Medallion Methodology
•Implemented a Delta Lake House Data-Mesh Framework
•Worked with two Dev Managers and a Product Managers to establish Data Governance
•Created a Data Dictionary containing the definitions for Data as a Product
•Led Paradigm Shift away from traditional IT ownership of delivering data to the Product Owners being responsible for delivery the data to consumers,
•Designed and implemented a three stage DataBricks Delta Lake Implementation
•Designed and implemented AWS Data Brew as a Pre-Processor to ETL Pipelines
•Architected and implemented AWS Glue for Crawling, Cataloging files for ingestion
•Designed and implemented AWS Glue and Python scripts as ETL pipelines.
•Data was categorized and transformed via DB Medallion Three State Methodology
a.Bronze - Raw Data
b.Silver - Sanitized Data
c.Gold - Aggregated Data
•Performed Discovery, Design, Implementation and Delivery for client projects that focused on Data and Databases.
Environment:
-Amazon Web Services Ecosystem
-DataBricks Enterprise on AWS
-DataBricks Delta Lake House
-S3 Buckets
-AWS IAM and Network Components
-IaC Cloud Formation
-Control Tower (provided landing zone and guardrails for account management)
-CI/CD Pipelines (Jenkins, GitHub)
-AWS Glue and Data Brew
-Python (Spark)
-AWS RDS Postgres
-AWS CloudWatch, PgAnalyze
-AWS Redshift
Triumph Tech LLC, New York, New York Jun 2021 – March 2022
AWS Data Architect
•Architected DataBricks deployment through Medallion Methodology
•Led team of three engineers and one project manager through analytics deployment
•Designed and implemented a three stage DataBricks Delta Lake Implementation
•Designed and implemented AWS Data Brew as a Pre-Processor to ETL Pipelines
•Architected and implemented AWS Glue for Crawling, Cataloging files for ingestion
•Designed and implemented AWS Glue and Python scripts as ETL pipelines.
•Data was categorized and transformed via DB Medallion Three State Methodology
a.Bronze - Raw Data
b.Silver - Sanitized Data
c.Gold - Aggregated Data
•Performed Discovery, Design, Implementation and Delivery for client projects that focused on Data and Databases.
•Design and Implemented Data Governance process, Data Dictionaries, and detailed Data Lineage
Environment:
-Amazon Web Services Ecosystem
-DataBricks Enterprise on AWS
-DataBricks Delta Lake House
-AWS Data Lakes
-S3 Buckets
-AWS IAM and Network Components
-IaC Cloud Formation
-Control Tower (provided landing zone and guardrails for account management)
-CI/CD Pipelines (Jenkins, GitHub)
-AWS Glue and Data Brew
-Python (Spark)
-AWS RDS Postgres
AWS CloudWatch, PgAnalyze
SCAN HealthCare Long Beach, Ca. December 2019 – March 2021
Sr. Database & Data-Warehouse Admin Architect
•Architected EDW incremental Daily load via SQL Server Change Tracking and Temporal Tables
•Designed, wrote, and implemented Objects Used and Not Used solution for EDW
•Reviewed and recommended Best Practices and Health Analyses protocol
•Help establish Dev-Ops model for future deployment
•Assisted in setting up Cloud Migration analyses initial deployment to MS Azure
•Assisted in Sql Server upgrade to SQL SERVER 2017 Enterprise and Standard
•Assisted Dev teams with performance tuning, deadlocking, database best practices.
•Worked with Infrastructure and vendor to optimize NetApp SAN per Sql Server Best Practice
•Implemented Data Governance and created a Data Dictionary to help map key measures.
•Initiate the use of Managed Service Accounts for automation and security requirements
Environment:
- SQL Server 2017, 2016, 2012 2008,
-SSIS
-SSRS
-SSAS
-Alteryx
-Azure Data Warehouse
-Azure Data Factory
-Azure Data Factory
-Azure Data Bricks
-Azure Dara Lakes
-Azure Synapse
Capital Group Irvine Ca. Feb 2019 – November 2019 Infosys Consulting
Sr. Engineer Dba – Architect (Project Lead)
•Managed offshore team consisting of DBAs and Operations members
•Participated in daily Sprint Standups, Sprint Planning and Sprint 0 Agile meetings
•Migrated and converted SQL SERVER Enterprise databases to AWS PostgreSQL, MySQL, Aurora
•Migrated Oracle to Sql Server and then ported up to AWS
•Participated in a DevOps team implementing robust product releases
•Infrastructure as Code images created via Terraform, and Ansible Playbooks
•Initiated the use of Ephemeral drives on EC2 instances for housing temp databases
•Worked with security team to implement Privileged Access Management to comply with GDPR
•Assisted Dev teams with performance tuning, deadlocking, database best practices
•Assisted in automation of Backups & Restore as a Service through Backup Exec
•Initiated the use of Managed Service Accounts for automation and security requirements
Environment:
- SQL Server 2016, 2012 2008
-SSIS
-SSRS
-Oracle
-PostgreSQL
-MySQL
-Aurora
-EC2, RDS Services
-EBS & Ephemeral Volume Storage
-MS Database Encryption – Column Level, TDE, Always Encrypted, PAM
-Disaster Recovery – Business Continuity via AOAG, Db Mirroring, Db Replication
Walt Disney Studios Glendale CA, June 2018 – December 2018
Sr. Engineer DBA - Architect
•Served as a senior Engineer DBA-Architect for the studios Business Systems Engineering team
•Participated in daily Sprint Standups, Sprint Planning and Sprint 0 Agile meetings
•Worked on Sprint stories created or assigned via sprint planning meetings
•Participated in a DevOps team implementing robust product releases
•Oracle to Sql Server Migration to comply with the MS Stack Approach
•Assisted in implementing Infrastructure as Code with SE team using Terraform, Chef
•Initiated the use of Ephemeral drives on EC2 instances for housing temp databases
•Initiated and guide POC Always Encrypted, TDE to satisfy corporate’s security mandate
•Worked on PAM environment for deploying code through Privileged Accounts & Domains
•Assisted Dev teams with performance tuning, deadlocking, database best practices
•Assisted in automation of Backups & Restore as a Service through Jenkins Pipeline
•Initiated the use of Managed Service Accounts for automation and security requirements
Environment:
- SQL Server 2016, 2012 2008
-SSIS
-SSRS
-Oracle 8i
-PostgreSQL
-EC2, RDS Services
-EBS, Bucket, Ephemeral Volume Storage
-MS Database Encryption - Column Level, TDE, Always Encrypted, PAM
-Disaster Recovery & Business Continuity via AOAG, Db Mirroring, Db Replication
Media Services Los Angeles CA, Feb 2016 – June 2017
Sr. DBA – Cloud Architect/ AWS Manager
•Served as a senior DBA servicing hosted AWS EC2 VPC solutions.
•Led all database projects for the Enterprise
•Acted as AWS Systems Manager and Admin
•Improved AWS day to day operations
•Created Cloud-Watch JSON scripts for monitoring and notification of Production Servers
•Used Agile Framework for project management and product delivery
•Participated in Sprint Planning and Reviews
•Helped design and implement DEV and PROD domains for PAM implementation
•Created PowerShell Scripts to automate and maintaining systems maintenance task
•Worked with dev and other database team members to troubleshoot production problems
•Managed and implemented migration to Sql Server 2016
•Mentored and advised junior developers and DBA with task, projects, and deliverables
•Reviewed code and project proposal with the development team
•Worked on building an AWS DR/BC environment with external consulting team
•Participated in audit team and implemented encryption to achieve Soc 1 Level 2 cert
•Implemented AWS Reserved Instance Purchases providing large savings
Environment:
- SQL Server 2016, 2012 2008
-SSIS
-SSRS
-.NET
-AWS EC2, RDS,
-MS AD, PAM Domain Security
-AWS cli, AWS management console expertise
-AWS, AMI, Encryption Key Management,
-AWS Lambda, JSON, PowerShell
-Linux Ubuntu, Red Hat, AWS Linux
Content. Ad Irvine, CA. Nov 2015 – Jan 2017
Sr. Cloud DBA
•Served as a senior DBA maintaining AWS EC2 and VPC environment
•Designed and implemented 3-Tier AOAG WSFC Solution on a VPC EC2 environment
•Created and implemented lower environments for development testing and code deployment
•Used Agile Framework for project management and product delivery
•Participated in Sprint Planning and Reviews
•Implemented Idera Sql Diagnostic Manager for monitoring production environments
•Worked with Systems and other database team members to troubleshoot production problems
•Architected full migration path from a 4 server SQL Server 2012 production mirrored environment to a 3 Node WSFC AOAG implementation. Included unit, systems, performance and parallel testing and final deployment.
Environment:
- SQL Server 2012, 2008 2005
-SSIS
-WSFC – AOAG, Db Mirroring, Transactional Replication
-Hadoop EMR, H-Bas,, Kafka
Wells Fargo Capital Finance Santa Monica. CA. Jun 2014 – Nov 2015
Systems Architect/Database Analyst
•Served as a senior consultant and architect for data center migration project
•Performed analyses, testing & migration of Capital Finance servers to centralized data centers
•Led DBA team in performance analyses of an Executive Dashboard
•Worked within a PAM environment separating Prod and lower environments through AD
•Implemented Regulatory Security process as mandated federal guidelines
•Initiated, wrote, and presented a ROOT CAUSE ANALYSES to management detailing the
system’s deficiencies. Recommendations to correct problems were part of the deliverables.
•Post implementation of my solution EOM completed in 30 minutes versus 5 hours.
•Worked with WFCF AND MS engineers to identify SAN performance problems throughout the Enterprise (Recommendations were made to move temp databases to local media, considerably improving performance on the core lending database applications)
•Recommendations were also made on storage architecture designs and best practices. LUNs and Aggregates were examined and re-aligned for optimal performance gains
•Worked on streamlining and optimizing the core applications as they related to SQL SERVER TRANSACTIONAL REPLICATION
•Agile Methodology was used throughout the Enterprise
Environment:
- SQL Server 2012, 2008 2005
-SSIS
-SSAS
-SSRS
-DR-BC
-Replication, DB Mirroring
-Sql Sentry Monitoring Tool
iConstituent Washington D.C. Mar 2008 – June 2014
Database Administrator/Director of Database Systems
•Served as a senior consultant and architect (A full time position was accepted after consulting)
•Principal duties included analysis, design, and implementation of a data warehouse
•Star and snowflake schemas were deployed to support BI requirements
•Reporting database was also designed and implemented for the OLAP environment
•Served as the primary DBA for the company’s core products
•Supported CRM, eNewsletter, Websites, Data Services and SharePoint for content management
•Analysis, design, and implementation via Agile and other methodologies
•Implemented Software, Hardware migrations, and Database and SharePoint Upgrades
•Performance Tuning and Db Optimization
•Products enabled elected officials the ability to manage constituent level projects
•The lists of clients include the US House of Representatives and the US Senate
Environment:
- SQL Server 2012, 2008 2005, 2000
-MySQL, Access, Cluster Servers
-SharePoint
-ColdFusion, Java
-MS Team-Test
-MS Visual Studio Professional
-MS Project
Investor’s Business Daily Marina Del Rey, Ca. Mar 2005 – Nov 2007
Database Administrator/Systems Architect – Consultant
•Served as senior consultant and architect for IT and IBD research departments
•Principle duties included designing and implementing a data warehouse
•A STAR schema was designed with fact and domain tables
•The system was built on SQL 2000 then migrated to 2005
•The OLTP database that was used to pull the data was Oracle 9i
•ETL tools were used to extract, and Stored Procedures were used to de-normalize the data
•Assisted production DBAs on Oracle and SQL SERVER running production OLTP data bases
•Helped tune queries on both engines and wrote DTS packages to migrate data
Environment:
-SQL Server 2000, 2005, Transact SQL
-Oracle 9i, 10g, PLSQL
-Visual Basic, Excel
-Visio, Erwin
-Sun Solaris, Windows
-EMC Media
Details available upon request for below roles
Health Care Partners Torrance, CA, Sep 2002 – Mar 2005 Database Administrator/Systems Architect – Consultant Toyota Motor Corp. Torrance, CA, Apr 2000 – Sep 2002 Database Administrator/Systems Architect – Consultant LA Times/Tribune Interactive Oct 1999 – Apr 2000 Database Administrator/Systems Architect – Consultant Guidance Solutions, Aug 1999 – Oct 1999
Database Administrator/Systems Architect – Consultant
Sony Picture Entertainment, Apr 1999 – Aug 1999 Database Administrator/Systems Architect – Consultant Los Angeles Times, Feb 1998 – Apr 1999
Database Administrator/Systems Architect – Consultant BNSF Santa Fe Pacific, L.P., Mar 1992 – Feb 1998 Database Administrator
PacifiCare Health Systems, Dec 1990 – Feb 1992
Senior Programmer/Analyst
Pacific Technical Resources, Jun 1990 – Dec 1990
Computer Consultant
EDUCATION
Bachelor of Science, Computer Science, University of Southern California, Los Angeles, CA. CERTIFICATIONS
•Certificate in Application Control Management Systems, Digital Equipment Corporation
•Certificate in Database System Internals, Digital Equipment Corporation/Oracle Corporation
•Certificate in Structured Analysis, Structured Systems, and Program Design, Yourdon
•Certified in Database Tuning and Design, Microsoft Corporation
•AWS Badges earned
•CCMI Development Model Framework for DOD and US Government projects.
Contact this candidate