The successful technical lead with focus mainly on backend technologies. Typical daily responsibilities:

• Use pgAdmin (Postgres management tool) to confirm the health of Postgres database server, and verify the completion of server based batch jobs
• Use AWS Security Hub to assess compliance with security baselines. If security issues are found:
  • remedy the problem or
  • task support teams via Jira requests
• Use VSCode to write Python scripts using pandas and boto3 to generate extracts of data and store those extracts to AWS S3 buckets
• Create AWS Lambda functions using Python to create exports in CSV and Parquet format.
• Research best practices for creating serverless solutions for database tasks. Solutions may include AWS Batch, AWS Fargate, and will work with Amazon Elastic Container Service (ECS) or Amazon Elastic Kubernetes Service (EKS).
• Create and update tasks/issues in Jira for tracking purposes.
• Create and update documentation in Confluence
• Maintain code repositories in git
• Monitor a public email mailbox and provide advice on using the HCRIS cost report data.

• The technical lead interacts with the ISSO, GTL and TL, providing technical support and provides instruction and guidance to the DBA in the completion of regularly scheduled and ad hoc tasks.
• The technical lead develops and tests new features and functionality to enhance the systems security and accessibility. The technical lead, with the help of the DBA, create new data products, usually simple extracts for CMS internal users.
• The technical lead is responsible for monitoring a publicly accessible mailbox and providing timely responses to questions about cost reports from the public and other government agencies.
• The technical lead also provides support for the ISSO, by maintaining current documentation in CMS security repository (CFACTS), participating in annual security documentation reviews, correcting any deficiencies in the HCRIS security configuration or practices.
• The technical lead examines new technology as it becomes available in the CMS/AWS environment and works with CMS and support staff in maintaining current best practices.
• Technical Lead Areas of Expertise
• Relational Database Use and Management, general
• Relational Database Use and Management, AWS RDS Postgres specific.
• AWS architecture
• NIST 800 series security instructions and compliance.
• Python programming
• SAS programming
• Technical writing for documentation and correspondence.