Database Administrator for SQL / Oracle

With Targetbase, clients no longer need to lose sleep trying to wrap their heads around technology and data. Instead, we focus them on connecting data—generating intelligence and applying it to the experience. It’s the secret to driving consumer engagements that drive behavior change and create measurable results. We’re ready to help. Targetbase.

The Database Administrator is responsible for designing, managing, administering, documenting, and providing technical and strategic support for business-critical database systems. He/she leverages senior-level experience to provide database-related technical support, database design, and data modeling to meet client objectives and/or Targetbase product needs.

• Accountable for ensuring client databases run efficiently
• Designs the information architecture for client specific databases and data marts and documents via data modeling – leverages knowledge of core database to provide detailed core data models maintained in ERwin
• Designs new databases – in addition to core database builds, leverages the appropriate methodologies to design Star Schemas for analytics and reporting
• Designs the implementation of ETL mappings using Informatica 8 or an equivalent tool
• Builds, adds, modifies, and deletes database tables
• Supports production teams with ad hoc database support requests
• Proactively monitors client database spaces to ensure appropriate allocations as environments grow
• Consults with client teams on data analysis, campaigns, and reporting projects
• 80% MS SQL DBA job duties and 20% Oracle DBA job duties

Performance Expectations

• Quality and overall impact of deliverables: Strives to achieve executional excellence. Ensures quality and timely execution of job responsibilities.
• Team and/or client feedback and satisfaction: Receives unsolicited, positive feedback
• Commitment to vision and guiding principles of agency and competency: Number one focus is on service and timely execution
• Organizational and/or technical knowledge: Has appropriate knowledge of his/her core competency and Targetbase’s integrated service offerings. Able to support both Technology and SBA competencies from a database standpoint.

Experience & Education

• 3+ years of experience and knowledge of designing, managing, developing, and documenting data warehouses and data marts
• Associate’s or Bachelor’s Degree in Computer Science, Engineering, MIS, or IIS

Knowledge & Ability

• SQL – DBA; PL/SQL; SQL*Plus; Reports; SQL Server MSSQL preferred
• ETL experience required (Informatica 8 – Data Quality, Data Explorer, Cleanse and Match is a plus)
• Erwin
• CIS experience preferred
• Star schemas; snowflake schemas
• Data Warehouse methodology
• Data solutions in an Azure environment
• ODBC
• Unix platforms, Windows, and .NET platforms
• Java, Perl, XML, C, C#, HTML, DHTML
• Unix shell scripting
• MS Office suite, Visio, and Project
• Network knowledge
• Project management skills

Position Requirements

• Overtime as necessary
• Flexibility to adapt to a changing environment