Job title: Database Administrator
Certifications: CompTIA Security+
Clearance: Active DoD Secret
Location: San Antonio, TX (fully remote)
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.
- 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)
Pay: $85,000.00 per year
Benefits:
- 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:
Work Location: Remote
