| Contract ROLE :: Data Architect (Oracle & MS SQL Server) :: Onsite in Tallahassee, FL at Tallahassee, Florida, USA |
| Email: [email protected] |
| From: Naved, rconsultinginc [email protected] Reply to: [email protected] Hi, I hope you're having a wonderful day. I'm Naved, representing Resource Consulting Services Inc. We have a new job opportunity available with one of our clients. If interested, please send us your resume and expected pay rate. Below, you'll find the details of the job role. Please let me know if you're interested. Position: Data Architect (Oracle & MS SQL Server) Locations: Onsite in Tallahassee, FL Duration: 8+ Months Contract Interview Process: Video Interview Job description: Minimum of 2 - 4 years of IT work experience with demonstrated knowledge in architecture design, software development, database management systems and systems integration in multi-platform environments. Advanced knowledge of data analysis techniques, database structures, and database theories. Proficient with Microsoft SQL Server. Experience with Oracle. Excellent oral and written communication skills; able to garner support from a wide variety of stakeholders. Experience working on multiple projects as a project leader or frequently as the subject matter expert. Preferred Qualifications: Certification in one or more of the following: Oracle Certified Professional. Microsoft Certified DBA, Microsoft Azure Administration, CompTIA A+, CompTIA Data+, CompTIA Server+. Experience with PL/SQL, T-SQL, P-SQL and MS SQL. Tasks: Create queries and accurately interpret multiple data sets; write shell scripts to automate repetitive tasks in order to streamline workflow; analyze and develop PL/SQL packages and execute T-SQL and P-SQL queries; analyze business procedures and recommend specific types of data to improve processes. Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency; provide staff with data resources from election related databases needed for case intake, investigation and management; transform specialized data into formatted reports. Propose and implements failover strategies. Performs database patches. Perform database upgrades and implements new features. Schedule the monitoring of successful database back-ups. Perform database restores as required. Responsible for conducting low level monitoring, access control, and performance of databases; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; monitor all database environments for capacity, integrity, and efficiency. Perform database tuning as needed to address performance issues; conducts proactive maintenance. Responsible for analysis and query execution plans and index utilization. Assist in the development of new applications, including system design, creation of tables, and setting performance metrics. Implement database schema modifications as required. Maintain change logs for all database configuration updates and changes for all database servers. Maintain change logs for user accounts and ensure security standards are implemented. Attend and participate in all project related meetings and assuring meeting notes are produced and distributed, as necessary. Correspond (verbally and in writing) with project team and internal stakeholders regarding project activities, deliverables, and status. Serve as senior subject matter expert. Recommend best practices in solution architecture. Scope of Work: Participate in all phases of the development and implementation process and may act as a project manager on special projects. Establish and manage a formalized solution architect for data development and maintenance projects. Provide appropriate documentation for object design decisions, estimating assumptions, applets, and performance metrics. Analyze assigned specifications, planning, designing, and developing solutions, utilizing appropriate Internet/Intranet/Extranet architecture processes supporting a wide range of content. SKILLS MATRIX FOR DATA ARCHITECT Experience Years of Exp Last Used Minimum of 2 - 4 years of IT work experience with demonstrated knowledge in architecture design, software development, database management systems and systems integration in multi-platform environments. Advanced knowledge of data analysis techniques, database structures, and database theories. Proficient with Microsoft SQL Server. Experience with Oracle. Experience working on multiple projects as a project leader or frequently as the subject matter expert. Create queries and accurately interpret multiple data sets; write shell scripts to automate repetitive tasks in order to streamline workflow; analyze and develop PL/SQL packages and execute T-SQL and P-SQL queries; analyze business procedures and recommend specific types of data to improve processes. Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency; provide staff with data resources from election related databases needed for case intake, investigation and management; transform specialized data into formatted reports. Propose and implements failover strategies. Performs database patches. Perform database upgrades and implements new features. Attend and participate in all project related meetings and assuring meeting notes are produced and distributed, as necessary. Correspond (verbally and in writing) with project team and internal stakeholders regarding project activities, deliverables, and status. Perform database restores as required. Schedule the monitoring of successful database back-ups. Responsible for conducting low level monitoring, access control, and performance of databases; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; monitor all database environments for capacity, integrity, and efficiency. Perform database tuning as needed to address performance issues; conducts proactive maintenance. Responsible for analysis and query execution plans and index utilization. Assist in the development of new applications, including system design, creation of tables, and setting performance metrics. Implement database schema modifications as required. Maintain change logs for all database configuration updates and changes for all database servers. Maintain change logs for user accounts and ensure security standards are implemented. Serve as senior subject matter expert. Recommend best practices in solution architecture. Thanks and Regards, Naved Khan Resource Consulting Services Inc. : [email protected] Keywords: information technology microsoft procedural language Florida Contract ROLE :: Data Architect (Oracle & MS SQL Server) :: Onsite in Tallahassee, FL [email protected] |
| [email protected] View all |
| Mon Sep 16 20:16:00 UTC 2024 |