Database Architect

Novalink Solutions LLC • Madison, WI

1d

About The Position

The Database Architect IV position will focus on database design and the ongoing support and
administration of SQL and Oracle databases for specific applications and development work for
DCF program areas. The DBA should be an expert at writing and debugging complex SQL and
understand the best ways to incorporate database requests into application programs. The
applicant must be capable of creating scripts and stored procedures, provide recommendations
for performance tuning, understand the complexities with change management in Software
Development Life Cycles and should have an understanding of the overall DBMS
implementation and knowledge that will help with formal design of relational databases and
provide insight into strategic data manipulation. This environment includes a variety of
application databases, data warehouses and multidimensional databases. General maintenance
will be required to clean and maintain the databases to include but not limited to removing and
deleting old data and system monitoring for Oracle and SQL database job functions. The
applicant should be familiar with a variety of the field’s concepts, practices, and procedures and
can rely on their extensive experience and judgement to plan and accomplish goals. This role
requires primary and current experience to be with SQL database solutions 2008 and 2012r.
Experience and knowledge with Oracle 11 and 12, SharePlex or Golden Gate for data migration
is recommended.
The job will require the person to communicate and collaborate with DCF internal and external
partners. This position does perform a variety of tasks; so a wide degree of creativity and
latitude is expected. Experience with enterprise class applications with mission critical
functionality which contain sensitive information such as PII is required. Experience with
government regulations on Security, data encryption as defined by the regulations is
recommended. Having experience with solutions used by the State of Wisconsin, such as
eWiSACWis, KIDS, and CARES is beneficial.
Rotating 24x7 on call may be required

Requirements

• Administer SQL-server and Oracle databases.
• Database Tuning and Maintenance to assure highest level of system availability and performance.
• Plan for disaster recovery tests and ensure the systems are fully resilient.

Nice To Haves

• Change Management 10
• Excellent oral and written communication skills 10
• Database Tuning and Maintenance to assure highest level of system availability and performance 10
• Implement Database Objects and Files needed by Database Applications 10
• Administer and enforce standards 10
• Ability to navigate and query a relational database (Oracle) 10
• Administer and enforce standards 10
• Back-out and forward recovery tools 10
• Bug reporting and tracking tools 10
• Create and implement maintenance plans 10
• Create database objects 10
• Data analysis 10
• Database Design 10
• Database monitoring tools 10
• Database security 10
• Data flow diagramming 10
• Data migration and archiving 10
• Oracle 11g 10
• Oracle Enterprise Manager 10
• SQL 2008 10
• SQL 2012 10
• Validate conceptual and logical model with customer 10
• SQL Analysis Services 10
• SQL – DTS 10
• SSRS 10
• Experience and knowledge with Oracle 11 and 12, SharePlex or Golden Gate for data migration is recommended.
• Experience with government regulations on Security, data encryption as defined by the regulations is recommended.
• Having experience with solutions used by the State of Wisconsin, such as eWiSACWis, KIDS, and CARES is beneficial.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed