Remove/unsubscribe | Update your contact and subscribed mailing list(s) | Subscribe to mailing list(s) to receive requirements & resumes
From:
Niki,
Parin Technologies
niki@parintec.com
Reply to: niki@parintec.com
Title: SQL Server DBA
Location: Richmond, VA
Hybrid: 2 days/week at the office.
Duration: 5 months+
Interview: Webcam and In-Person
Job Description :
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 on-demand to support the existing Windows SQL server databases hosted. The current DBA’s will work to support the 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 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