Database Administrator
DBHDS - Database Administrator 4 (758490)
DBHDS - Database Administrator
Location : Richmond, VA Hybrid
ON SITE: 2-3 days a week ON SITE and then as requested by Mgr.
Parking NOT provided for contractors
Pls note: Mgr will conduct initial Web based IVs but reserves the right to bring in selected candidates for a follow up IN PERSON interview if they deem necessary.
Complete Description
A database administrator (DBA) is an IT professional responsible for managing, maintaining, and securing an organization's databases, ensuring data is stored, organized, and accessible for analysis and business operations; oversee db administration tasks like installation, configuration, backup, security, performance monitoring, and troubleshooting database issues.
ABOUT THE ROLE
Main Responsibilities of a Database administrator
The following list describes the typical responsibilities and deliverables of a Database administrator:
Core Responsibilities
Perform SQL Server Monitoring
Perform SQL Server Daily Check
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
After Hour Support
To Note: We expect the consultant to be available as on-demand to support the existing Windows SQL server databases hosted in VITA. The current DBA s will work to support the VITA in the event of any windows server, SQL server databases patches and upgrades occurs at least once or twice per month.
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
Additional responsibilities include:
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 DataManagement 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
Implement a modern cloud datastore (Snowflake) to handle both structured and unstructured data.
Enable automation using scripting languages like Python or Node.js.
Provide support and training to end-users to enhance data literacy and tool usage within the cloud data ecosystem.
Analyze the data lifecycle of business processes to identify opportunities for automation, simplification, and implementing appropriate solutions.
Set up monitoring, logging, and alerting for cloud infrastructure to ensure system stability and performance.
Optimize deployment pipelines for Continuous Integration and Continuous Deployment (CI/CD).
Manage version control using tools like Github, Jenkins and AWS Code Pipeline.
Collaborate with senior team members and business stakeholders to deliver robust, cloud-based data solutions that improve customer experience.
Support data governance activities to ensure data reliability, quality, and compliance with standards.
Assist in designing scalable and resilient cloud engineering solutions aligned with evolving business needs.
Develop both front-end and back-end components for cloud-based data applications as needed.
Required / Desired Skills | ||||
Skill | Required / Desired | Response ( Candidate years of experience) | Amount | of Experience |
Proficiency in database configuration and management tools | Required | 8 | Years | |
Knowledge of, and experience with performance tuning, scripting and automation, troubleshooting and resolving application issues | Required | 7 | Years | |
Proficient with database monitoring, database security, database tuning | Required | 7 | Years | |
Proficiency with database administration tools for database monitoring, performing routine tasks and troubleshooting issues | Required | 7 | Years | |
Experience with data migration in large-scale enterprise environments and data synchronization and replication techniques | Required | 7 | Years | |
Hands on experience with data engineering activities on the AWS cloud to support data integration, data storage | Required | 7 | Years | |
Hands on experience in using AWS db services including S3, Aurora, postgres, DynamoDB, Iceberg, and Snowflake. | Required | 5 | Years | |
Core experience of configure data management practices on AWS using native services such as AWS Glue, AWS Data Zone, AWS Glue Data Catalog,API Gateway | Required | 5 | Years | |
Familiarity with version control using tools like Github, Jenkins and AWS Code Pipeline | Required | 5 | Years | |
Ability to handle multiple tasks and prioritize effectively | Required | 7 | Years |
S
DBHDS - Database Administrator 4 (758490)
DBHDS - Database Administrator
Location : Richmond, VA Hybrid
ON SITE: 2-3 days a week ON SITE and then as requested by Mgr.
Parking NOT provided for contractors
Pls note: Mgr will conduct initial Web based IVs but reserves the right to bring in selected candidates for a follow up IN PERSON interview if they deem necessary.
Complete Description
A database administrator (DBA) is an IT professional responsible for managing, maintaining, and securing an organization's databases, ensuring data is stored, organized, and accessible for analysis and business operations; oversee db administration tasks like installation, configuration, backup, security, performance monitoring, and troubleshooting database issues.
ABOUT THE ROLE
Main Responsibilities of a Database administrator
The following list describes the typical responsibilities and deliverables of a Database administrator:
Core Responsibilities
Perform SQL Server Monitoring
Perform SQL Server Daily Check
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
After Hour Support
To Note: We expect the consultant to be available as on-demand to support the existing Windows SQL server databases hosted in VITA. The current DBA s will work to support the VITA in the event of any windows server, SQL server databases patches and upgrades occurs at least once or twice per month.
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
Additional responsibilities include:
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 DataManagement 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
Implement a modern cloud datastore (Snowflake) to handle both structured and unstructured data.
Enable automation using scripting languages like Python or Node.js.
Provide support and training to end-users to enhance data literacy and tool usage within the cloud data ecosystem.
Analyze the data lifecycle of business processes to identify opportunities for automation, simplification, and implementing appropriate solutions.
Set up monitoring, logging, and alerting for cloud infrastructure to ensure system stability and performance.
Optimize deployment pipelines for Continuous Integration and Continuous Deployment (CI/CD).
Manage version control using tools like Github, Jenkins and AWS Code Pipeline.
Collaborate with senior team members and business stakeholders to deliver robust, cloud-based data solutions that improve customer experience.
Support data governance activities to ensure data reliability, quality, and compliance with standards.
Assist in designing scalable and resilient cloud engineering solutions aligned with evolving business needs.
Develop both front-end and back-end components for cloud-based data applications as needed.
Required / Desired Skills | ||||
Skill | Required / Desired | Response ( Candidate years of experience) | Amount | of Experience |
Proficiency in database configuration and management tools | Required | 8 | Years | |
Knowledge of, and experience with performance tuning, scripting and automation, troubleshooting and resolving application issues | Required | 7 | Years | |
Proficient with database monitoring, database security, database tuning | Required | 7 | Years | |
Proficiency with database administration tools for database monitoring, performing routine tasks and troubleshooting issues | Required | 7 | Years | |
Experience with data migration in large-scale enterprise environments and data synchronization and replication techniques | Required | 7 | Years | |
Hands on experience with data engineering activities on the AWS cloud to support data integration, data storage | Required | 7 | Years | |
Hands on experience in using AWS db services including S3, Aurora, postgres, DynamoDB, Iceberg, and Snowflake. | Required | 5 | Years | |
Core experience of configure data management practices on AWS using native services such as AWS Glue, AWS Data Zone, AWS Glue Data Catalog,API Gateway | Required | 5 | Years | |
Familiarity with version control using tools like Github, Jenkins and AWS Code Pipeline | Required | 5 | Years | |
Ability to handle multiple tasks and prioritize effectively | Required | 7 | Years |
S