SQL Database Architect
T and T Consulting Services

Job Info

---

Project Overview:

Proving DB re-engineering for a 15k+ user system at the National Institutes of Health (NIH). The candidate will work on a mission critical system that is utilized for acquisitions across the NIH. The system was home grown and expanded to serve over 26 of the institutes and centers. To drive performance, cost savings, and critical acquisition analytics our team is looking for a DB Architect to re-work the current set up - built in multiple SQL Servers - to bring to a more modern and enterprise approach for data processing and data warehousing. This exciting project is both a re-vamp of the current system as well as keeping an eye on future modernization of the whole system (i.e. Front-end rebrand, AI/ML, automated order processing, ad hoc reporting, cloud transformation, etc.) The current DB is built in Microsoft SQL Server 2012. The project is open to new technologies (RDS, MySQL, PostgreSQL, Aurora, etc.) Looking forward to working with a motivated candite who is ready to assist our Application Team, PM, and Solution Architect in modernizing a critical NIH System.

Primary Responsibilities:

• Improve existing Database and Storage design to build an optimized and efficient database system
• Reengineering the design and come up with new design ideas and options using innovative technologies
• Design, develop, and support core Data Warehouse and/or Data Mart processes.
• Perform Reporting, Scaling, Architecting, Operating, Maintenance on the existing DB system
• Creating detailed documentation and diagrams
• Understanding of various RDBMS products (Postgres, SQL Server, etc.), Dataflow, Tables Schemas, Connections between DBs, Table Joins, Views
• Collaborative mindset to work with Application team , Infrastructure Team, leadership Team and other Contractors coming up with DB solution in a holistic fashion and not as temporary fix.

Required Skills & Qualifications:

• BA or BS degree
• 5+ years of experience building data flow using ETL tools is required
• Experience with a variety of data ingestion techniques and tools such as consumption and parsing of JSON docs, and Data replication tools.
• The ability to architect and model mission-critical RDMS, BI, OLTP, OLAP, and solutions leveraging multiple DBMS technologies is required; Ability to create new schemas on how production databases run, tune, and maintain in a production environment
• Extensive experience with Data Analysis, Data Profiling, Data Flows, and Data Modeling is required.
• 5+ years of SQL experience and DB design, optimization, and administration
• Design, develop, and maintain, proficient in SQL tuning techniques, queries, code, and ETL processes.
• Create database/programming scripts based upon user submitted requirements.
• Provide rational analysis of data and means to improve structure and integrity.
• Design ERDs and produce high quality engineering design documents
• Specify proper types of files organization, indexing methods, and security procedures by advising project teams on the design of complex databases and data lakes.
• Defines and prepares specialized database reports documentation.
• Performs detailed comparisons of various database systems and works closely with server team to provide data storage strategies, backup, recovering, archival policies and procedures.
• Performs administration tasks (installing, maintaining, monitoring, recovering, rebuilding, upgrading, patching, profiling, and performance tuning).
• Experience in the day-to-day operation, maintenance, management, and troubleshooting of Microsoft SQL; Experience in a production environment supporting Microsoft SQL, accessed by 15000+ users
• Analyze, interpret, or disseminate system performance data.
• Administer document and system access rights and revision control to ensure security of system and integrity of documents and transactions.
• Develop, document, and maintain standards, best practices, or system usage procedures.
• Consult with end-users regarding problems in accessing electronic records system.
• Experience programming and requesting information from RESTful endpoints

Desired Skills & Qualifications:

• Net, .Net Core Experience, API
• Experience programming in an object-oriented language
• Experience working with Big Data
• Experience programming systems that interface with AWS resources (particularly any of the following: Lambda, Step Function, S3, DynamoDB, Glue, Data Pipeline, Systems Manager, Secrets Manager, Database Migration Service)
• Experience programming and requesting information from RESTful endpoints
• Experience querying Elasticsearch or OpenSearch
• Experience using any of the following: Travis CI or Jenkins, Docker/Docker Hub, Datadog, Sentry, JIRA, Confluence, DBeaver, pgAdmin, JetBrains IDEs
• Program systems, scripts, and queries in conjunction with SQL Server, Oracle databases, NoSQL databases(Like MongoDB),Snowflake, on both on-prem and cloud environments with DB such as. Amazon RDS, AWS Glue, PostgreSQL, MySQL, DynamoDB, Elasticsearch;Microsoft Azure cloud data services (or equivalent) utilizing Functions, Data Factory, Managed Instances

Benefits: Competitive benefits package including: health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

Equal Opportunity Employer/Veterans/Disabled

This job has expired.