drjobs DBHDS - Database Administrator 4

DBHDS - Database Administrator 4

Employer Active

1 Vacancy
The job posting is outdated and position may be filled
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Richmond - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

DBHDS DBA
ON SITE: 23 days a week ON SITE and then as requested by Mgr.
Parking NOT provided for contractors
MAX VENDOR RATE: ############


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.

DBHDS Database Administrator

Complete Description

A database administrator (DBA) is an IT professional responsible for managing maintaining and securing an organizations 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 responsibilitiesand 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 databaseadministrator 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 ondemand tosupport the existing Windows SQL server databases hosted in VITA. The current DBAs will work to support the VITA in the eventof any windows server SQL server databases patches and upgrades occurs atleast once or twice per month.
  • Perform database validations after VITA patching
  • Troubleshoot nonstandard job issues including extended delays and failures due to network latency issues blocking and old code sets not being updated or optimized
  • Afterhour 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 endusers 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 cloudbased 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 frontend and backend components for cloudbased data applications as needed.

Required/Desired Skills Skill Required /Desired 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 largescale 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 CatalogAPI 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 Questions No. Question Question1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment Question2 Please list candidates email address. Question3 In what city and state does your candidate currently reside If you indicate Richmond then please upload a recent utility bill OR drivers license to confirm the candidates local address. Upload at time of submittal under the Reference tab Question4 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. Does your candidate agree to this arrangement Question5 If selected role requires 23 days ON SITE each week. Addl days maybe requested as needed. Does your candidate agree to this arrangement

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.