Database DBA
This program requires US Citizenship or Green Card (Lawful Permanent Residents) Public Trust Washington, DC Working at the Department of Transportation headquarters in Washington DC. Candidates must be on-site at the customer location 2 days/week with potential to switch to full 5 days/week.
Experience:
Must have a minimum of 10 years of related experience as a database administrator, specializing in supporting Oracle and SQL environment. Duties:
Designs the database server architecture, to include installation, maintenance, and configuration. Performs troubleshooting and resolution management. Provides support for advanced user jobs and analytics. Top Qualifications, Skills, Experience or Certifications:
1. SQL Cluster 2. Always-On Cluster 3. Distributed Always-On Cluster 4. SQL Replication 5. On-premises to Azure Migration 6. Azure Managed Instance 7. SQL STIG (Security Technical Implementation Guides) 8. TDE (Transparent Data Encryption) 9. SQL Certified DP-300 Certification (a plus) Job Role
Specific Requirements:
1. Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both prod/dev/test environments. 2. Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises. 3. Build and manage Azure managed instances and Azure managed databases. 4. Facilitate database migration from on-premises environments to Azure. 5. Execute SQL database upgrades, migrations, backups, and restores. 6. Administer user access by provisioning SQL logins and users based on project requirements. 7. Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues. 8. Establish AG listeners and add databases to Always On while handling failover scenarios. 9. Implement and troubleshoot database mirroring solutions. 10. Configure and troubleshoot database log shipping setups. 11. Set up and troubleshoot database transaction replication configurations. 12. Manage SQL clusters and resolve cluster-related issues. 13. Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks. 14. Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking. 15. Configure database mail for SQL job alerts. 16. Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management. 17. Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019). 18. Create and manage incident/changes using the Service Now ticketing system. 19. Provide exceptional on-demand customer service. 20. Collaborate with application teams to troubleshoot application issues from a database perspective. 21. Demonstrate expertise in Transparent Data Encryption (TDE). 22. Implement SQL Server Security Technical Implementation Guides (STIG) compliance. The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position's responsibilities; the candidate's experience, education, and skills; location; travel required; and current market conditions. Benefits (Regular, Full Time Employees):
Medical, Dental, and Vision offerings Weekly Direct Deposit Paid Holidays and Personal Time Off 401(k) with match Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages Pre-Paid Legal and Employee Assistance Programs Northwest Federal Credit Union Membership BB&T @ Work Program ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans Maintain database backup/recovery procedures and disaster recovery database environment Maintain database backup/recovery environment Execute database backup/recovery procedures Perform tuning the database/application Assist with tuning database performance Maintain database security and database software Implement database tuning changes to maintain optimum database performance Do database tuning and performance monitoring Implement database backup and recovery Manage backup/recovery for database instances Provide database support including backup/recovery Resolving database issues including database performance problems Perform database tuning and performance monitoring Monitoring database system performance and maintaining database security Evaluating database performance and adjusting database configuration Create databases and database maintenance procedures Develop database backup and recovery procedures Perform database recovery and backup procedures Optimize database performance and provide performance tuning Perform database index/statistic tuning Recommended Skills Architecture Customer Service Data Analysis Database Migration Disaster Recovery Infrastructure As A Service (Iaa S) Apply to this job. Think you're the perfect candidate? Apply Now $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
Experience:
Must have a minimum of 10 years of related experience as a database administrator, specializing in supporting Oracle and SQL environment. Duties:
Designs the database server architecture, to include installation, maintenance, and configuration. Performs troubleshooting and resolution management. Provides support for advanced user jobs and analytics. Top Qualifications, Skills, Experience or Certifications:
1. SQL Cluster 2. Always-On Cluster 3. Distributed Always-On Cluster 4. SQL Replication 5. On-premises to Azure Migration 6. Azure Managed Instance 7. SQL STIG (Security Technical Implementation Guides) 8. TDE (Transparent Data Encryption) 9. SQL Certified DP-300 Certification (a plus) Job Role
Specific Requirements:
1. Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both prod/dev/test environments. 2. Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises. 3. Build and manage Azure managed instances and Azure managed databases. 4. Facilitate database migration from on-premises environments to Azure. 5. Execute SQL database upgrades, migrations, backups, and restores. 6. Administer user access by provisioning SQL logins and users based on project requirements. 7. Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues. 8. Establish AG listeners and add databases to Always On while handling failover scenarios. 9. Implement and troubleshoot database mirroring solutions. 10. Configure and troubleshoot database log shipping setups. 11. Set up and troubleshoot database transaction replication configurations. 12. Manage SQL clusters and resolve cluster-related issues. 13. Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks. 14. Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking. 15. Configure database mail for SQL job alerts. 16. Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management. 17. Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019). 18. Create and manage incident/changes using the Service Now ticketing system. 19. Provide exceptional on-demand customer service. 20. Collaborate with application teams to troubleshoot application issues from a database perspective. 21. Demonstrate expertise in Transparent Data Encryption (TDE). 22. Implement SQL Server Security Technical Implementation Guides (STIG) compliance. The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position's responsibilities; the candidate's experience, education, and skills; location; travel required; and current market conditions. Benefits (Regular, Full Time Employees):
Medical, Dental, and Vision offerings Weekly Direct Deposit Paid Holidays and Personal Time Off 401(k) with match Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages Pre-Paid Legal and Employee Assistance Programs Northwest Federal Credit Union Membership BB&T @ Work Program ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans Maintain database backup/recovery procedures and disaster recovery database environment Maintain database backup/recovery environment Execute database backup/recovery procedures Perform tuning the database/application Assist with tuning database performance Maintain database security and database software Implement database tuning changes to maintain optimum database performance Do database tuning and performance monitoring Implement database backup and recovery Manage backup/recovery for database instances Provide database support including backup/recovery Resolving database issues including database performance problems Perform database tuning and performance monitoring Monitoring database system performance and maintaining database security Evaluating database performance and adjusting database configuration Create databases and database maintenance procedures Develop database backup and recovery procedures Perform database recovery and backup procedures Optimize database performance and provide performance tuning Perform database index/statistic tuning Recommended Skills Architecture Customer Service Data Analysis Database Migration Disaster Recovery Infrastructure As A Service (Iaa S) Apply to this job. Think you're the perfect candidate? Apply Now $(document).ready( function() $(#ads-desktop-placeholder).html(
n
n
n Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
