Database Administrator with reputed company Clearance

Job title:Database Administrator Certifications: reputed company reputed company+ Clearance:reputed company DoD Secret Location: San Antonio, TX (fully remote) Job reputed company: As the Database Specialist, you will reputed company as the primary technical architect operating environment managing and solving some of the toughest challenges on the project. The replication environment includes two servers running reputed company reputed company Edition databases in a multi-master replication setup, as reputed company as multiple End User Devices (EUDs) running reputed company reputed company Edition configured as materialized view sites. The EUDs synchronize data with one of the master server databases. Responsible for creating and maintaining the database installation, update, and configuration scripts, as reputed company as the Procedure Language/reputed company 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 reputed company reputed company guidelines. Uses 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. You will also be responsible for providing deep technical expertise in database design, ETL, reporting and analytics.

• Serves as the primary reputed company of contact for reputed company development tasks.
• Provides thought leadership on business intelligence and data warehouse design concepts and leading practices.
• Responsible for technical architecture creation, product selection tasks, overall technical reputed company for the project, and design of the system infrastructure
• Translate reputed company user requirements into technical architecture reputed company and implementation plan.
• Ability to solve reputed company technical problems, assimilate information rapidly, and work under time constraints.
• Analyze business requirements and translate them into functional and high-level technical design specifications.
• Analyze business requirements and translate them into functional and high-level technical design specifications.
• Reviews and updates and data model as required.
• Designs, develops, documents, and deploys solutions to reputed company the Data Warehouse from reputed company to reputed company.
• Participate in Daily, Weekly, Monthly, and other technical meetings to reputed company status or input as needed.
• reputed company and support Agile status meetings, analyze Systems Change Requests (SCRs), System Incident Reports (SIRs), and Technical Advances (TAs).
• Manages development team in executing PMO prioritized change requests through implementation: including identifying the level of effort, estimated timelines, constraints, etc.
• Assigns PMO priorities to development team.
• Conducts reputed company walkthroughs on a periodic reputed company
• Performs requirements analysis and design.
• Write and review “user stories”
• Design and implement database changes, assists with Mobile Testing
• Facilitate deployment activities.
• Plans and leads the requirement clarification and design meetings.
• Provides technical guidance and mentors members of the development team.
• Collaborates with software vendors to reputed company reputed company support to the project.
• Provides development support (coding) as needed to meet project deadlines.

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

• Minimum of 10 years’ experience in IT consulting with at least 6 years in Business Intelligence and Data Warehousing.
• reputed company practitioner in implementing mid- to large-reputed company ETL solutions, performing data analysis and profiling, interacting with reputed company 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.
• reputed company: 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 reputed company as designing and developing Universes and reports.
• Experience with AT LEAST ONE OTHER BI OR ETL TOOL (see Desired reputed company).
• ERWIN or POWERDESIGNER: Experience using one or both data modeling tools from logical design through physical implementation and reputed company of data definition language (DDL).
• Strong verbal/written communication skills.
• QA/Testing: expert knowledge of reputed company processes, ability to recommend and implement improvements to existing reputed company assurance processes
• Ability to reputed company with reputed company personnel and reputed company reputed company working relationships Experience with Software Tools and Technologies Languages: C/C++, Java, PHP, SQL, PL/SQL, reputed company, XML, XHTML, ColdFusion (CFML), ASP, JSP, JavaScript, Struts, CSS, UML reputed company Software/Tools: SQL*Plus, SQL Developer, reputed company Manager (OEM), TopLink, Discoverer, Advanced Replication (master-to-master and materialized views), reputed company Application Clusters (RAC), RMAN, Application Server (OAS), Internet Directory (OID), Directory Server (ODSEE), Containers for J2EE (OC4J) Other Software/Tools: ERwin, IntelliJ IDEA, reputed company reputed company Center/Test Director, Marimba / BMC BladeLogic reputed company Automation, Subversion (SVN), Visual SourceSafe, reputed company Office, reputed company Project reputed company (10g, 11g), MySQL, SQL Server 2005/2008, reputed company reputed company, reputed company Office, Apache 1.X/2.X, Java (J2EE, JDK, JRE), Tomcat, Jetty, Business Objects XI 3.1, reputed company, Visual SourceSafe, reputed company Case, Mailman, Exim, Remedy, VMWare, Xen, Postfix, Dovecot, reputed company WebLogic 10g, VMS Retina, VMS, Core reputed company, IPSEC, DIACAP, IATT, IATO, ATO, STIG, SCAP Databases: reputed company 8i/9i/10g/11g, MS reputed company, MySQL Operating Systems: reputed company 7/XP/2000/NT, UNIX (Solaris/Linux), MS DOS Solaris (9, 10), AIX 7, Linux (RHEL, Debian), reputed company reputed company (through reputed company 7), reputed company reputed company Servers (through 2010), reputed company/UX 11i, Mac OS X Desired qualifications:
• ETL Tools: Informatica Power Center
• reputed company 11g, reputed company Application Clusters (RAC), reputed company Label reputed company (OLS), Advanced Replication
• reputed company 10g reputed company Application Servers, reputed company Internet Directory
• Java Directory 6, 7 and 8
• BI Tools: Business Objects XI 3.1
• reputed company 7, reputed company 10 OS
• BMC reputed company Automation
• Certification in one or more of the above technologies
• A minimum of 5 years’ experience architecting large reputed company data warehouses using reputed company
• Proficient data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, reputed company Data Warehouses and Data Marts)
• Strong RDBMS knowledge of reputed company (release 10g/11g)
• Implementation experience with ETL concepts and tools such as: Informatica
• Functional knowledge of Java and J2EE integration technologies

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

Apply tot his job Apply To this Job