RICEFW Technologies
SoGA - DPH - Senior Database Administrator - Atlanta, GA - HYBRID
RICEFW Technologies, Atlanta, Georgia, United States, 30383
We're seeking a highly qualified candidate for the position of Senior Database Administrator within the Office of Information Technology.
*Candidate MUST be local to Metro Atlanta*
The ideal candidate will work with leadership to implement standard operating procedures for managing databases, install configure and setup database instances, review and implement separation of duties, RACI matrix, and security controls. Implement back-up schedules across all databases.
The ideal candidate will serve as an advisor and project team member for setting new databases instances for new applications as well as supporting existing databases within DPH. Below is an overview of several key applications the Department is looking to implement or replace: •Deploying a common Electronic Health Record application (EHR) across the state with clinical management, pharmacy and analytic capabilities will provide the technical platform necessary to support a more comprehensive understanding of the public health impact and public health operations. •The COVID-19 pandemic has put tremendous pressure on all aspects of DPH and specifically on of our core data systems, our State Electronic Notifiable Disease Surveillance System (SendSS) and our Georgia Registry of Immunization Transaction Services (GRITS). Both of these systems are over 15 years old and have shown deficiencies during the pandemic related to infrastructure and to how data is managed and accessed. Both of these systems are in the procurement phase to be replaced.
Job Responsibilities: •Define data conversion, data quality, and data cleansing criteria for COTS vendors •Work with vendors to integrate COTS based solutions within DPH •Design, build, upgrade and patch highly available database solutions for mission critical applications •Perform database tuning as needed to optimize application performance •Troubleshoot database related outages as part of a larger team supporting other layers of the technology environment •Proven experience converting data from one database platform to another such as Oracle to MS SQL Server •Proven experience building and managing high scalable database solutions on cloud platforms •Guide the design, development, deployment and management highly reliable and scalable databases •Enforce company policies in areas of database design, security, change management, compliance documentation and separation of duties
Job Qualifications: •15+ years experience building, maintaining, securing and backing up databases across multiple platforms such as Oracle and MS SQL Server. •3+ years experience working with configuring database solutions in a cloud environment such as Microsoft Azure or AWS •15+ years experience working with data cleansing, data conversions, data migrations •15+ years providing enterprise application and database operational support •10+ years application development experience with languages such as: Java, .NET, Json, Java Script, C#, etc. 10+ years building, integrating, or implementing COTS enterprise level database solutions for State Government agencies 5+ years implementing infrastructure architecture that supports enterprise applications 3+ years experience designing and implementing high availability systems
Required Skills: •Thinks strategically, understands the big picture but is also able to execute on tactical operational situations working with disparate databases •Solves complex problems and drives action across the organization •Clearly articulate integration issues with vendors working on COTS and/or custom applications with the ability to drive results and develop solutions •working with Server Engineers, preparing specifications for the database servers, monitoring and tuning the application databases, and establishing communication links across Database Management Systems •directs and controls activities relating to database management, planning, development, and security •Ability to work with multiple database products such as Oracle, MS SQL server, MySQL, Amazon RDS, Postgres etc. •Experience working with TOAD, Visual Studio, WebLogic, JBOSS, SQL, PL/SQL, .NET, C#, Java, XML, and SQL Developer
Education Required: •Bachelor Degree from an accredited University in computer science, or related field
Required/Desired Skills Skill Required /Desired Amount of Experience Consultant Experience 15+ years experience building, maintaining, securing and backing up databases across multiple platforms such as Oracle and MS SQL Server. Required 15 Years 3+ years experience working with configuring database solutions in a cloud environment such as Microsoft Azure or AWS Required 3 Years 15+ years experience working with data cleansing, data conversions, data migrations Required 15 Years 15+ years providing enterprise application and database operational support Required 15 Years 10+ years application development experience with languages such as: Java, .NET, Json, Java Script, C#, etc. Required 10 Years 10+ years building, integrating, or implementing COTS enterprise level database solutions for State Government agencies Required 10 Years 5+ years implementing infrastructure architecture that supports enterprise applications Required 5 Years 3+ years experience designing and implementing high availability systems Required 3 Years
Questions No. Question Consultant Answer Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question2 Please list candidate's email address. Question3 This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement? Question4 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client's selection date. Do you accept this requirement? Question5 HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement? Question6 Where does the candidate resides?
*Candidate MUST be local to Metro Atlanta*
The ideal candidate will work with leadership to implement standard operating procedures for managing databases, install configure and setup database instances, review and implement separation of duties, RACI matrix, and security controls. Implement back-up schedules across all databases.
The ideal candidate will serve as an advisor and project team member for setting new databases instances for new applications as well as supporting existing databases within DPH. Below is an overview of several key applications the Department is looking to implement or replace: •Deploying a common Electronic Health Record application (EHR) across the state with clinical management, pharmacy and analytic capabilities will provide the technical platform necessary to support a more comprehensive understanding of the public health impact and public health operations. •The COVID-19 pandemic has put tremendous pressure on all aspects of DPH and specifically on of our core data systems, our State Electronic Notifiable Disease Surveillance System (SendSS) and our Georgia Registry of Immunization Transaction Services (GRITS). Both of these systems are over 15 years old and have shown deficiencies during the pandemic related to infrastructure and to how data is managed and accessed. Both of these systems are in the procurement phase to be replaced.
Job Responsibilities: •Define data conversion, data quality, and data cleansing criteria for COTS vendors •Work with vendors to integrate COTS based solutions within DPH •Design, build, upgrade and patch highly available database solutions for mission critical applications •Perform database tuning as needed to optimize application performance •Troubleshoot database related outages as part of a larger team supporting other layers of the technology environment •Proven experience converting data from one database platform to another such as Oracle to MS SQL Server •Proven experience building and managing high scalable database solutions on cloud platforms •Guide the design, development, deployment and management highly reliable and scalable databases •Enforce company policies in areas of database design, security, change management, compliance documentation and separation of duties
Job Qualifications: •15+ years experience building, maintaining, securing and backing up databases across multiple platforms such as Oracle and MS SQL Server. •3+ years experience working with configuring database solutions in a cloud environment such as Microsoft Azure or AWS •15+ years experience working with data cleansing, data conversions, data migrations •15+ years providing enterprise application and database operational support •10+ years application development experience with languages such as: Java, .NET, Json, Java Script, C#, etc. 10+ years building, integrating, or implementing COTS enterprise level database solutions for State Government agencies 5+ years implementing infrastructure architecture that supports enterprise applications 3+ years experience designing and implementing high availability systems
Required Skills: •Thinks strategically, understands the big picture but is also able to execute on tactical operational situations working with disparate databases •Solves complex problems and drives action across the organization •Clearly articulate integration issues with vendors working on COTS and/or custom applications with the ability to drive results and develop solutions •working with Server Engineers, preparing specifications for the database servers, monitoring and tuning the application databases, and establishing communication links across Database Management Systems •directs and controls activities relating to database management, planning, development, and security •Ability to work with multiple database products such as Oracle, MS SQL server, MySQL, Amazon RDS, Postgres etc. •Experience working with TOAD, Visual Studio, WebLogic, JBOSS, SQL, PL/SQL, .NET, C#, Java, XML, and SQL Developer
Education Required: •Bachelor Degree from an accredited University in computer science, or related field
Required/Desired Skills Skill Required /Desired Amount of Experience Consultant Experience 15+ years experience building, maintaining, securing and backing up databases across multiple platforms such as Oracle and MS SQL Server. Required 15 Years 3+ years experience working with configuring database solutions in a cloud environment such as Microsoft Azure or AWS Required 3 Years 15+ years experience working with data cleansing, data conversions, data migrations Required 15 Years 15+ years providing enterprise application and database operational support Required 15 Years 10+ years application development experience with languages such as: Java, .NET, Json, Java Script, C#, etc. Required 10 Years 10+ years building, integrating, or implementing COTS enterprise level database solutions for State Government agencies Required 10 Years 5+ years implementing infrastructure architecture that supports enterprise applications Required 5 Years 3+ years experience designing and implementing high availability systems Required 3 Years
Questions No. Question Consultant Answer Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question2 Please list candidate's email address. Question3 This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement? Question4 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client's selection date. Do you accept this requirement? Question5 HYBRID work option: However, the selected candidate must be available to report onsite as directed by the client. Do you accept this requirement? Question6 Where does the candidate resides?