Database Administrator

BEAT LLC
San Antonio, TX, United States
23 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$85,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Access ASP.NET HTML Java (Programming Language) JavaScript (Programming Language) PHP (Programming Language) Extensible HyperText Markup Language (XHTML) Microsoft Windows IBM AIX Data Analysis Apache HTTP Server Apache Tomcat
+62 more
Server Applications Apple Mac Systems Oracle WebLogic Server Unix C++ (Programming Language) Cascading Style Sheets (CSS) ColdFusion Markup Language IBM Rational ClearCase Adobe Coldfusion Profiling Information Technology Consulting Databases Extract Transform Load (ETL) Data Warehousing Database Design Debian Linux Linux Oracle Discoverer DOS (Disk Operating System) Java Platform Enterprise Edition (J2EE) HP Quality Centers HP-UX IntelliJ IDEA Internet Protocol Security (IP SEC) Java Development Kit Apache Struts Javaserver Pages Microsoft Office Microsoft Project Microsoft SQL Server Windows Servers MySQL Citrix Systems Oracle Databases Oracle (Applications) Oracle Rac PowerDesigner Red Hat Enterprise Linux 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 Extensible Markup Language (XML) Jetty Marimba BladeLogic Database Performance Sap Business Objects Er-Win Postfix Extreme Programming 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

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:13 min

Evaluating UML, block diagrams, and the C4 model

Simon Lasselsberger · WWC 2022

2:21 min

Projecting external HTML content using default and named slots

Rowdy Rabouw Rowdy Rabouw · WWC 2022

2:03 min

Microsoft integrating native Unix coreutils into Windows environments

Chris Heilmann +2 · LIVE

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

4:36 min

Visualizing system architecture with Mermaid UML diagrams

Jakov Semenski · LIVE

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all