Note: The job is a remote job and is open to candidates in USA. BEAT is seeking a Database Administrator who will act as the primary technical architect managing complex database environments. The role involves designing and implementing database solutions, providing expertise in business intelligence and data warehousing, and leading a development team to meet project objectives.
Responsibilities
- Act as the primary technical architect operating environment managing and solving some of the toughest challenges on the project
- Create and maintain the database installation, update, and configuration scripts, as well as the Procedure Language/Structured Query Language (PL/SQL) packages and procedures used in configuring and performing replication between the mobile portion of the application running on tablet PCs and the central web application, in accordance with DISA security guidelines
- Use Computer Associates’ ERwin Data Modeler software to design the database, to generate SQL scripts containing Data Definition Language (DDL) for the database, and to generate the Data Dictionary documentation
- Provide deep technical expertise in database design, ETL, reporting and analytics
- Serve as the primary point of contact for all development tasks
- Provide thought leadership on business intelligence and data warehouse design concepts and leading practices
- Responsible for technical architecture creation, product selection tasks, overall technical strategy for the project, and design of the system infrastructure
- Translate client user requirements into technical architecture vision and implementation plan
- Ability to solve complex technical problems, assimilate information rapidly, and work under time constraints
- Analyze business requirements and translate them into functional and high-level technical design specifications
- Review and update the data model as required
- Design, develop, document, and deploy solutions to populate the Data Warehouse from source to target
- Participate in Daily, Weekly, Monthly, and other technical meetings to provide status or input as needed
- Lead and support Agile status meetings, analyze Systems Change Requests (SCRs), System Incident Reports (SIRs), and Technical Advances (TAs)
- Manage development team in executing PMO prioritized change requests through implementation: including identifying the level of effort, estimated timelines, constraints, etc
- Assign PMO priorities to the development team
- Conduct code walkthroughs on a periodic basis
- Perform requirements analysis and design
- Write and review 'user stories'
- Design and implement database changes, assist with Mobile Testing
- Facilitate deployment activities
- Plan and lead the requirement clarification and design meetings
- Provide technical guidance and mentor members of the development team
- Collaborate with software vendors to provide optimal support to the project
- Provide development support (coding) as needed to meet project deadlines
Skills
- Minimum of 10 years' experience in IT consulting with at least 6 years 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: At least 3 years' 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
- Required education: Bachelor's Degree (master's degree desired)
- Required experience: Business Intelligence: 6 years
- Database and Data Warehouse: 5 years
- US Citizenship
- IT Consulting: 10 years
- ETL Tools: Informatica Power Center
- Oracle 11g, Real Application Clusters (RAC), Oracle Label Security (OLS), Advanced Replication
- Oracle 10g R2 Application Servers, Oracle Internet Directory
- Java Directory 6, 7 and 8
- BI Tools: Business Objects XI 3.1
- Windows 7, Windows 10 OS
- BMC Client Automation
- Certification in one or more of the above technologies
- A minimum of 5 years' experience architecting large scale data warehouses using Oracle
- Proficient data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts)
- Strong RDBMS knowledge of Oracle (release 10g/11g)
- Implementation experience with ETL concepts and tools such as: Informatica
- Functional knowledge of Java and J2EE integration technologies
Benefits
- Fully remote
Company Overview