data architect - pl/sql, t-sql, p-sql, ms sql

$145,600 - $166,400/Yr

Randstad - Tallahassee, FL

Full-time - Mid Level

Tallahassee, FL

Administrative and Support Services

About the position

This is a 100% onsite position in Tallahassee, FL, offering a contract role with a pay range of $70 - $80 per hour. The position requires a candidate with 2 to 4 years of IT work experience, demonstrating knowledge in architecture design, software development, database management systems, and systems integration across multi-platform environments. The ideal candidate will possess advanced knowledge of data analysis techniques, database structures, and database theories, along with proficiency in Microsoft SQL Server and experience with Oracle. Familiarity with government information technology standards and processes is also essential. The role involves participating in the analysis of current systems to understand inputs and outputs, engaging in all phases of the development and implementation process, and potentially acting as a project manager on special projects. Responsibilities include establishing and managing a formalized solution architect for data development and maintenance projects, providing documentation for object design decisions, and analyzing specifications to develop solutions that support a wide range of content. The candidate will also serve as a senior subject matter expert, recommend best practices in solution architecture, and ensure compliance with customer IT processes. Additional tasks include creating queries, writing shell scripts to automate tasks, developing data models, and transforming specialized data into formatted reports. The position requires conducting low-level monitoring, access control, and performance management of databases, as well as performing database tuning and proactive maintenance. The candidate will maintain change logs for database configuration updates and user accounts, ensuring security standards are implemented.

Responsibilities

• Participate in the analysis of current system(s) to gain an understanding of inputs and outputs.
• 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.
• Attend and participate in all project related meetings and assure 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.
• Follow customer IT processes and coordinate with other IT staff to ensure compliance with standards.
• 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 implement failover strategies. Perform database patches.
• Perform database upgrades and implement new features. Schedule the monitoring of successful database back-ups. Perform database restores as required.
• Conduct low level monitoring, access control, and performance of OECS 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; conduct 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.

Requirements

• 2 to 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.
• Knowledge of and experience with government information technology standards and processes.
• Proficient with Microsoft SQL Server.
• Experience with Oracle.
• Experience with IT systems and processes, methodologies and their direct implementation to projects.
• Experience working on multiple projects as a project leader or frequently as the subject matter expert.
• Goals-oriented proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Excellent oral and written communication skills; able to garner support from a wide variety of stakeholders.
• Critical thinker with excellent problem-solving skills that can make independent decisions within area of responsibility and expertise.

Nice-to-haves

• 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.

Benefits

• Comprehensive benefits package including health insurance, an incentive and recognition program, and 401K contribution.