AWS Datastore Solutions Architect

Playing an essential role in the U.S. economy, Fannie Mae is foundational to housing finance. Here, your expertise can help fuel purpose-driven innovation that expands access to homeownership and affordable rental housing across the country. Join Fannie Mae to grow your career and help people find a place to call home.

Job Description

As a valued contributor to our team, you will provide expert advice to the team and participate in designing, developing, testing, and/or maintaining hardware, technology, and/or processes.

THE IMPACT YOU WILL MAKE

The AWS Datastore Solutions Architect  is responsible for driving the Fannie Mae database Cloud Pattern Development and Manage the Catalog of Services. The advisor is also responsible for driving the adoption across a diverse user community.

The AWS Datastore Solutions Architect  role will offer you the flexibility to make each day your own, while working alongside people who care so that you can deliver on the following responsibilities:

• Participate in discovery or visioning phase to create a high-level design approach and key architectural decisions that impact the business

• Develop a cloud native architecture that optimizes flexibility, scalability, performance and resiliency

• Frequently interact with the business, aligned with the Product, to integrate knowledge of the business and functional priorities

• Work side-by-side with developers on new patterns

• Recommend new technologies and identify innovation opportunities to improve service architecture strategy

• Participate in the DWG to review and ensure design is aligned with defined principles

• Develop and socialize cloud service patterns that support business application consumption.

• Serve as the final accountability on the service portfolio and roadmap decisions for cloud patterns.

• Ensure products are enterprise ready

THE EXPERIENCE YOU BRING TO THE TEAM
Minimum Required Experiences

• 6 years

Desired Experiences

• 8+ years of Experience

• Bachelor degree or equivalent

Strong technical resource in the area of Database Engineering/Administration and DevOps Automation with AWS, and cloud IAAS and PAAS for managed database and supporting technologies. This role specializes in end to end AWS DB Cloud tool development and database automation, from data store selection to Implementation in production.  The role requires expert hands-on knowledge of Redshift, Aurora-Postgres, AWS database migration tool, AWS Schema Conversion tool, and RDS, EC2, DMS, SCT,  EMR, Athena, Kinesis, Elastic Beanstalk, Lambda, Step-Functions, ECS , VPC, CloudWatch, Document DB, Neptune, Sagemaker, S3, IAM ,SNS. Ideal candidate should have good experience with DevOps and Sysops with associated AWS Certifications.

DevOps/Automation skills:

• Development of  automation tasks for automate Entitlement management for Oracle database.

• Development of scripts to automate back and restore in Oracle, MS Sql server and PostgreSQL.

• Development of  automation script for installing and monitoring various middleware tools.

• Development of scripts using Python, Perl and Shell scripting

• Development of CI/CD pipeline using AWS Code build and code pipeline.

• Flyway implementation for applications

Skill Set Summary:

UNIX Shell Scripting, Windows PowerShell, Python, PL/SQL, PL/PGSQL, Ruby DSL , JSON, YAML, Spark ,HQL, Gremlin ,SQL

 AWS Services:RDS, EC2, DMS, SCT, Redshift, EMR, Athena, Elastic Beanstalk, Lambda, Step-Functions, ECS , VPC, CloudWatch, Document DB, Neptune, Sagemaker, S3, IAM ,SNS BI & Analytics :Tableau , Splunk , Quick sight

ETL: Talend, Pentaho

Bigdata: Hadoop Hortonworks, AWS EMR, Gluent

NoSQL: HBase, Dynamo, Neptune, Mongo/Document DB, Cassandra

Cloud Environment: Amazon AWS, Microsoft Azure

RDBMS/SQL: Oracle 11x/12x/19x, Postgres 9.6.x/10.x/11.X, MS-SQL Server 2008/2012/2014, Amazon RDS, Aurora, Amazon Redshift

Architecture /modelling: ER Studio Data architect, Gliffy, Lucid Chart, MS Visio

Monitoring: Cloudwatch,  Splunk, Moogsoft AIOps, SiteScope

Data movement: Oracle Goldengate, Delphix, Sqoop, AWS DMS

IDEs: Visual studio code, Eclipse, Jupyter Notebooks Version control tools:Git , Bit bucket, Flyway

Infrastructure Automation: AWS Cloudformation , Terrafrom

Agile Tools: Jira, Leankit

Ticketing: ServiceNow, HPSM, JIRA

Collaboration tool: SharePoint, Confluence

Certifications and Rewards: Oracle, AWS

Cloud Infrastructure - Engineering - Advisor

Target Salary Range: $152,000 to $205,000 a year

#LI-Hybrid

Qualifications

Education:

The future is what you make it to be. Discover compelling opportunities at Fanniemae.com/careers.

For most roles, employees are expected to work onsite on a regular basis at their designated office location. In-office work cadence is determined by your manager. Proximity within a reasonable commute to your designated office location is preferred unless the job is noted as open to remote.

Fannie Mae is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity/gender expression, marital or parental status, or any other protected factor. Fannie Mae is committed to providing reasonable accommodations to qualified individuals with disabilities who are employees or applicants for employment, unless to do so would cause undue hardship to the company. If you need assistance using our online system and/or you need a reasonable accommodation related to the hiring/application process, please complete this form.

The hiring range for this role is set forth below. Final salaries will generally vary within that range based on factors that include but are not limited to, skill set, depth of experience, certifications, and other relevant qualifications. This position is eligible to participate in a Fannie Mae incentive program (subject to the terms of the program). As part of our comprehensive benefits package, Fannie Mae offers a broad range of Health, Life, Voluntary Lifestyle, and other benefits and perks that enhance an employee's physical, mental, emotional, and financial well-being. See more here.

Requisition compensation:

to