Business Enabled Acquisition and Technology, Inc.
Database Administrator
Location
Texas
Posted
3 days ago
Salary
0
Seniority
Lead
Job Description
Database Administrator
BEAT
• As the Database Specialist, you will act 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 Oracle Enterprise Edition databases in a multi-master replication setup, as well as multiple End User Devices (EUDs) running Oracle Enterprise Edition configured as materialized view sites. • Responsible for creating and maintaining 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. • 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 point of contact for all 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 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. Reviews and updates and 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). • 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 code walkthroughs on a periodic basis.
Job Requirements
- 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.
Benefits
- Certifications: CompTIA Security+
- Clearance: Active DoD Secret
- Flexible work arrangements
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
Senior Database Administrator
Allied UniversalAllied Universal, founded in 2016 with the merger of AlliedBarton Security Services and Universal Services of America, is now a widely-recognized industry leader and North America�
Role Description Allied Universal® is hiring a Senior Database Administrator. The Senior Database Administrator is responsible for the design, administration, security, optimization, availability, and support of enterprise database platforms. Serving as a senior technical resource, this role provides leadership in database architecture, performance tuning, disaster recovery, automation, and data integration initiatives. The position partners closely with application development, infrastructure, cybersecurity, and business teams to ensure database environments are secure, stable, scalable, and aligned with organizational objectives, while also serving as an escalation point for complex production issues and database-related projects. Responsibilities: - Database Administration: - Administer Microsoft SQL Server and related database technologies. - Ensure availability, reliability, performance, and recoverability of production, development, test, and disaster recovery environments through installation, upgrades, migrations, patching, maintenance, backup, recovery, monitoring, capacity planning, and growth forecasting. - Performance Monitoring and Optimization: - Optimize database performance through indexing, query tuning, execution plan analysis, and system configuration improvements. - Identify and resolve application and database performance bottlenecks. - Establish database development, performance, and optimization standards; review application code and database structures. - Database Architecture and Design: - Support database architecture, technology planning, schema design, data modeling, and integration initiatives. - Participate in enterprise projects to ensure scalability, maintainability, and alignment with business requirements. - Evaluate emerging technologies and recommend improvements. - Security and Compliance: - Implement and maintain security controls, access management, and privileged account governance in accordance with corporate, regulatory, audit, cybersecurity, and compliance requirements. - Support vulnerability remediation, security assessments, and protection of sensitive and regulated data. - Disaster Recovery and Business Continuity: - Develop, maintain, test, and validate disaster recovery procedures, backup recovery processes, recovery objectives, and business continuity plans. - Automation and Operational Excellence: - Develop automation solutions using T-SQL, PowerShell, SQL Agent, and related technologies to improve efficiency through scripting, monitoring, alerting, and self-healing processes. - Maintain operational documentation, standard operating procedures, and database administration standards. - Application and Development Support: - Support application deployments, production releases, reporting, integration, and analytics solutions. - Partner with development teams on database design, coding best practices, and troubleshooting database-related application issues. - Leadership and Collaboration: - Serve as a senior technical advisor and mentor for database technologies. - Participate in project planning, estimation, and technical reviews while effectively communicating with technical and business stakeholders. - Provide after-hours support and participate in on-call rotations as required. Qualifications - Must possess one of the following: - Bachelor’s degree in Computer Science, Information Systems, Information Technology, or related field of study. - Associate’s degree in Computer Science, Information Systems, Information Technology, or related field of study with a minimum of seven (7) years of progressively responsible database administration experience. - High school diploma or equivalent with a minimum of ten (10) years of progressively responsible database administration experience. - Minimum of five (5) years of progressively responsible database administration experience. - Minimum of three (3) years of experience supporting mission-critical Microsoft SQL Server environments. - Experience supporting high-availability enterprise systems, database performance tuning, backup and recovery strategies, disaster recovery solutions, and on-premises and cloud-hosted database environments. - Experience with SQL Server Agent, SSIS, SSRS, Always On Availability Groups, Replication, Database Mirroring, and backup/recovery methodologies. - Experience with PowerShell scripting, automation, database monitoring, performance analysis, data modeling, database design, troubleshooting, and root-cause analysis. - Advanced Microsoft SQL Server administration and T-SQL programming skills. - Strong project leadership, oral and written communication skills. - Ability to manage multiple priorities in a dynamic enterprise environment. Preferred Qualifications - Experience with Azure SQL, Azure Managed Instance, Oracle, PostgreSQL, MySQL, data warehousing, business intelligence, CI/CD, DevOps, infrastructure-as-code, and automation frameworks. - Microsoft SQL Server and/or Azure certifications. - Experience in highly regulated industries and supporting SOX, PCI, CMMC, DFARS, HIPAA, or similar compliance frameworks. Benefits - The anticipated salary range is $110,000 – $120,000 annually. - Medical, dental, vision, basic life, AD&D, retirement plan and disability insurance. - Eight paid holidays annually, five sick days, and four personal days. - Vacation time offered at an accrual rate of 3.08 hours biweekly; unused vacation is only paid out where required by law.
• Design, deploy, and administer PostgreSQL databases supporting cloud-native applications and microservices. • Manage Azure Database for PostgreSQL (Flexible Server and Hyperscale/Citus), ensuring high availability, scalability, and disaster recovery. • Monitor, troubleshoot, and optimize database performance for mission-critical production environments. • Lead database modernization initiatives, including migrations from on-premises and legacy platforms to Azure. • Partner with Platform Engineering, DevOps, and SRE teams to enable automated deployments and infrastructure best practices. • Develop and maintain backup, recovery, security, and compliance strategies. • Build automation using Infrastructure as Code (Terraform/Bicep) and scripting languages such as Python, Bash, or PowerShell. • Establish monitoring, alerting, and operational best practices for PostgreSQL platforms. • Provide technical leadership and mentor engineers on PostgreSQL administration, performance tuning, and database best practices.
Role Description The Database Design and Data Management professional is responsible for designing, implementing, maintaining, and analyzing enterprise databases to ensure data integrity, accessibility, and performance across multiple applications. - Design logical and physical database structures. - Develop, implement, and maintain enterprise and workgroup databases. - Develop stored procedures and optimize database performance. - Perform database backups, recovery, and performance tuning. - Conduct data integration, mapping, and validation. - Collect, organize, and analyze datasets using statistical methods and machine learning tools. - Develop data visualization tools and analytical models to support decision-making. Qualifications - Bachelor's degree from an accredited four-year college or university. - Preferred coursework in Computer Science, Data Science, Information Systems, or Database management. Requirements - Minimum 2 years of full-time paid experience in database design, administration, data analysis, or data management. - Experience with enterprise data systems and distributed information systems.
Database Administrator
Hyphen SolutionsSoftware solutions connecting Home Builders and Suppliers, designed to support the entire building process.
• This position manages AWS RDS (MySQL 8.0 and PostgreSQL 15) databases that support large scale application workloads. • The DBA ensures the performance, reliability, and security of the data layer while collaborating closely with application engineering teams. • The role is responsible for managing, optimizing, and supporting the organization’s database environments, with emphasis on SQL query development and performance tuning. • The DBA serves as the primary escalation point for database and data related issues and works with internal teams to maintain dependable data access across applications. • The DBA also partners with customer care to troubleshoot reported problems and executes operational scripts as required.



