Job Title: Computer Programmer II (Database Consultant)
Responsibilities:
Perform SQL Server Monitoring Provide database support for scheduled deployments Provide database support for troubleshooting issues Automation of tasks to reduce required level of manual intervention Track database connections and log the information Enforced ISO security requirements and policies Conduct an audit of databases access Automate alerts for expired/expiring passwords for users in database administrator group Check for unauthorized membership to database administrator group Report user access anomalies to ISO (Information Security Officer) Upgrade older SQL versions to a supported SQL version to take advantage of new security features Management of OLTP and OLAP SQL Server environments Power BI administration and support Snowflake administration and support
Required Skills:
Perform data engineering activities on the cloud to support data integration, data storage, data consumption, and data governance initiatives. Experience with AWS services including S3, Aurora, DynamoDB Configure Data Management practices on AWS using native services such as AWS Glue, AWS Data Zone, AWS Glue Data Catalog, API Gateway, and AWS Lambda. Leverage/Manage Datastores like Snowflake, SQL servers, RDS 3+ years of experience in Implementing a modern cloud datastore (Snowflake) to handle both structured and unstructured data.Experience in AWS EC2, AWS RDS, AWS EBS, AWS IAM, and AWS S3 Experience using SQL language in any MySQL or Oracle databases.
- 3+ years of experience: big data using NoSQL like MongoDB or Spark in developing distributed processing applications; building applications with immutable infrastructure in the AWS (Amazon Web Services) Cloud with automation technologies like Terraform or Ansible or CloudFormation.
- Perform database validations after VITA patching
- Troubleshoot non-standard job issues including extended delays and failures due to network latency issues, blocking and old code sets not being updated or optimized
- After-hour DBA support requested in advance for enhancements and break fixes
- Perform unplanned database restore by working with VITA
Qualifications:
- Bachelor//'s degree in computer science, Engineering, or related field.
- Certification in the related technologies is desirable.
