DBHDS - Database Administrator 4
Yakshna Solutions - Virginia, Minnesota, United States, 55792
Work at Yakshna Solutions
Overview
- View job
Overview
Mar 14 2025 ID Job Title Job Description 758490 DBHDS - Database Administrator 4 Yakshna Solutions, Inc
is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprise, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serving its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services. We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance. 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. 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 Enforce 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 on-demand to support the existing Windows SQL server databases hosted in VITA. The current DBAs will work to support VITA in the event of any Windows server, SQL server databases patches and upgrades occurring 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
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 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. YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. #J-18808-Ljbffr