Database Administrator

BEAT LLC
San Antonio, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 85K

Job location

Remote
San Antonio, United States of America

Tech stack

Microsoft Access
ASP.NET
HTML
Java
JavaScript
PHP
Extensible HyperText Markup Language (XHTML)
Microsoft Windows
IBM AIX
Data analysis
Apache HTTP Server
Tomcat
Server Applications
Apple Mac Systems
Oracle WebLogic Server
Unix
C++
CSS
ColdFusion Markup Language
IBM Rational ClearCase
Adobe Coldfusion
Profiling
Information Technology Consulting
Databases
ETL
Data Warehousing
Database Design
Debian Linux
Linux
Oracle Discoverer
DOS
Java Platform Enterprise Edition (J2EE)
HP Quality Centers
HP-UX
IntelliJ
Internet Protocol Security (IP SEC)
Java Development Kit
Apache Struts
Javaserver Pages
Microsoft Office
Microsoft Project
Microsoft SQL Server
Windows Server
MySQL
Citrix Systems
Oracle
Oracle Applications
Oracle Rac
PowerDesigner
Red Hat Enterprise Linux - RHEL
Software Tools
Recovery Manager (RMAN)
Microsoft Visual SourceSafe
Security Content Automation Protocol
Solaris (Operating System)
SQL Stored Procedures
PL-SQL
SQL*Plus
SQL Databases
Subversion
TopLink
UML
Xen Servers
XML
Jetty
Marimba
BladeLogic
Database Performance
Sap Business Objects
Er-Win
Postfix
Extreme Programming (XP)
Directory Server
VMware

Job description

This position will be responsible for tracking, monitoring and reporting on all work assigned by the Program Manager and will require the candidate to assist in the efficient assignment and organization of work, scheduling and planning projects ad hoc requests and issues. Ensure timely upward and downward status reporting.

Requirements

  • Experience in IT consulting with experience in Business Intelligence and Data Warehousing.
  • Experienced practitioner in implementing mid- to large-scale ETL solutions, performing data analysis and profiling, interacting with client management, leading ETL teams, and designing and architecting DW ETL solutions.
  • INFORMATICA: Experience in Informatica version 8.x or higher design and development is a must. Informatica certifications desirable.
  • ORACLE: Experience in database performance optimization techniques, multidimensional database designs, and physical database implementations.
  • In-depth knowledge of BI best practices and data modeling techniques a must. Capable of writing sophisticated queries and PL/SQL stored procedures.
  • BUSINESS OBJECTS: Strong background in BO 6.5 and XI. Experience installing and configuring BO, as well as designing and developing Universes and reports.
  • Experience with AT LEAST ONE OTHER BI OR ETL TOOL (see Desired Elements).
  • ERWIN or POWERDESIGNER: Experience using one or both data modeling tools from logical design through physical implementation and generation of data definition language (DDL).
  • Strong verbal/written communication skills.
  • QA/Testing: expert knowledge of quality processes, ability to recommend and implement improvements to existing quality assurance processes
  • Ability to interact with client personnel and develop positive working relationships

Experience with Software Tools and Technologies

Languages: C/C++, Java, PHP, SQL, PL/SQL, HTML, XML, XHTML, ColdFusion (CFML), ASP, JSP, JavaScript, Struts, CSS, UML

Oracle Software/Tools: SQL*Plus, SQL Developer, Enterprise Manager (OEM), TopLink, Discoverer, Advanced Replication (master-to-master and materialized views), Real Application Clusters (RAC), RMAN, Application Server (OAS), Internet Directory (OID), Directory Server (ODSEE), Containers for J2EE (OC4J)

Other Software/Tools: ERwin, IntelliJ IDEA, HP Quality Center/Test Director, Marimba / BMC BladeLogic Client Automation, Subversion (SVN), Visual SourceSafe, Microsoft Office, Microsoft Project Oracle (10g, 11g), MySQL, SQL Server 2005/2008, Microsoft Access, Microsoft Office, Apache 1.X/2.X, Java (J2EE, JDK, JRE), Tomcat, Jetty, Business Objects XI 3.1, Citrix, Visual SourceSafe, Clear Case, Mailman, Exim, Remedy, VMWare, Xen, Postfix, Dovecot, Oracle WebLogic 10g, VMS Retina, VMS, Core Impact, IPSEC, DIACAP, IATT, IATO, ATO, STIG, SCAP

Databases: Oracle 8i/9i/10g/11g, MS Access, MySQL

Operating Systems: Windows 7/XP/2000/NT, UNIX (Solaris/Linux), MS DOS Solaris (9, 10), AIX 7, Linux (RHEL, Debian), Microsoft Windows (through Windows 7), Microsoft Windows Servers (through 2010), HP/UX 11i, Mac OS X

Required education:

  • Bachelor's Degree (master's degree desired)

Benefits & conditions

Pulled from the full job description

  • Professional development assistance
  • Tuition reimbursement
  • Parental leave
  • Health insurance
  • Retirement plan
  • 401(k) matching
  • Paid time off, * 401(k) matching
  • Dental insurance
  • Flexible schedule
  • Health insurance
  • Health savings account
  • Life insurance
  • Paid time off
  • Parental leave
  • Professional development assistance
  • Retirement plan
  • Tuition reimbursement
  • Vision insurance

License/Certification:

  • CompTIA Security+ (Required)

Security clearance:

  • Secret (Required)

Apply for this position