Big Data/aws Lead Resume
2.00/5 (Submit Your Rating)
Sterling, VA
SUMMARY:
- Over 20+ years of hands on Experience and author of database reference books.
- Over 20 years of Database Architect/Database Administrator on multiple databases including Oracle, Sybase, SQL Server, PostGreSQL, MySQL.
- Over 5+ years of experience on MongoDB, DynamoDB.
- Over 6+ years of experience on AWS cloud, application migration, RDS setup and configuration.
- Hands on experience and case presentations on RDS vs Aurora.
- Database disaster recovery, database security, performance optimization are focus areas.
- Well rounded experience in Big Data, Hadoop, HBase, Hive, Impala, Confidential, Confidential and eco - system on Confidential
- A strong believer in process automation, operations cost optimization.
- Highly skilled in application/database design, ETL design, scripting (Unix shell, PHP, PERL).
- Database migrations from private cloud to public cloud like AWS. Creation of AWS EC2 instances suitable for Oracle/MySQL and migrate databases from private cloud to AWS. Setting up Oracle data guard, optimizing the total grid is part of this function.
- PostGreSQL AWS RDS instance setup, configuration, pg tools including but not limited to pgadmin, psql.
- Enterprise architecture Confidential .
SKILLS:
Oracle 7.5, DBA, HTML, CGI, Unix shell scripting, Perl, and production support DBA., Informatica
EXPERIENCE:
Confidential, Sterling, VA
Big Data/AWS lead
Responsibilities:
- As Big Data Architect, some of the big data implementations that I defined, designed and architected include:
- Log aggregator and log analytical system where various heterogeneous log data are accumulated, in a data lake concept.
- Log data is structured and synced with cloud repository using both Kinesis and Kafka depending on the app nature.
- Data finally stored at rest to NoSQL databases.
- Scala or Python is used to perform application logic before saving data at rest.
- A POC performed to evaluate Microsoft Azure, with ETL operations, data science operations to figure out data relations, coefficient analysis, and classifications.
- Additional Big Data projects included traditional RDBMS migration to Hadoop using many hadoop ecosystem components in particular the flume, sqoop and HIVE.
- Working on setting up, configuring Confidential and Hadoop processing system based on Confidential .
- Capacity planning, system monitoring, cost optimization, multi-threading analytic engines on Confidential .
- In depth Spark programming/Scala, end-point configuration and data analysis
Confidential, Reston, VA
Senior Oracle DBA, Senior Sybase DBA
Responsibilities:
- Worked on IBM contract at Confidential, in Reston VA until Nov 2016.
- DBA Team Lead for one of the largest IBM DBA teams.
- Regular duties include every aspect of managing 1000s of Oracle databases, including but not limited to upgrading, patching, writing PL/SQL triggers, stored procedures, optimizing the procedures and providing day to day support. Automating the operations with cost optimization in goal with shell scripts, perl and PHP scripts.
- In depth hands on work on Redshift Data Warehousing, EMR automation with microservices and Lambda functions
Direct Contractor
Confidential
Responsibilities:
- Database design, database systems design, architect the full SDLC complaint database infrastructure.
- Migrate On-Premise databases/applications to public cloud; define public cloud security policies
- AWS RDS/Aurora for MySQL and PostGreSQL
- Database and application migration using Confidential
- Writing scripts to automate migrations
- PostGreSQL RDS setup, configuration, P&T, user/role management, and support
- Writing Python/Shell Scripts to move data from on-premise databases/flat files to S3 buckets
- Creating Hive tables from S3 buckets and make them available to applications
- Presenting case studies
- Presented to Confidential DBA team
- Differences between RDS and Aurora
- Kinesis, kafka as data migration tools
- Datalake concepts and Datalake creation methods (meetup)
Confidential, Sterling VA
Data Architect
Responsibilities:
- Defined data architecture for one of the complex Sybase data repository for Security and Exchange Commission very large security monitoring database.
Confidential, Washington, DC
Oracle Database Architect, Big Data Analyst
Responsibilities:
- Defined, developed a full scale Oracle database production architecture.
- Implemented on-premise oracle database instances, standby instances and provided full time support for one of the mission critical applications to maintain warehouse management.
- Supported both SQL Server and MySQL in the team.
- Later migration Oracle to AWS.
- Migrated some Oracle instances to MySQL using Oracle GoldenGate
- Heavily involved with puppet, Jenkins.
- BigData: Hadoop 1.0 design and implementation:
- Requirements analysis
- Metadata collection
- Evaluation of Big Data tools to define classic click through analysis for the company web properties behavior and sales analysis
- Used Confidential to mount Hadoop namenode to port data from the databases on batch method of lambda architecture.
