Database Administrator 2

Ampcus Incorporated

Austin, TX

JOB DETAILS
SKILLS
Access Control, Analysis Skills, Benchmarking, Business Intelligence, Business Intelligence Software, Business Services, Communication Skills, Computer Security, Consulting, Data Mart, Data Modeling, Data Processing, Data Quality, Data Recovery, Data Warehousing, Database Administration, Database Analysis, Database Design, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Database Programming, Database Technology, Disability Accommodations, Disaster Recovery, Documentation Standards, Hyperion, IBM Cognos, IBM WebSphere DataStage, Informatica, Information/Data Security (InfoSec), Interpersonal Skills, Management Reporting, Metadata, MicroStrategy, Microsoft SQL Server, Multitasking, NCR Teradata, Oracle, Oracle DBA (Database Administrator), Performance Analysis, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Relational Databases (RDBMS), Reporting Skills, Requirements Management, SAP BusinessObjects, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Snowflake Schema, Software Evaluation, Software Migration, Star Schema, Team Player, Writing Skills
LOCATION
Austin, TX
POSTED
12 days ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

 

Job Title: Database Administrator 2

Location(s): Austin, TX


Summary:
Seeking Database Administrator 2 professionals with experience in database administration, data warehousing, data modeling, ETL processes, database performance tuning, security administration, disaster recovery, and enterprise reporting environments. Candidates will support database installation, upgrades, migrations, security controls, performance optimization, backup/recovery processes, and data warehouse initiatives.

Key Responsibilities:

  • Install, upgrade, test, and support database management systems and database software migrations.
  • Design, analyze, modify, and maintain database structures and environments.
  • Implement backup, recovery, and disaster recovery procedures.
  • Establish and maintain database security controls and user access management.
  • Monitor database performance and implement tuning and optimization strategies.
  • Develop and maintain database documentation, standards, policies, and procedures.
  • Design logical and physical data models, including relational database structures.
  • Support data warehouse development, maintenance, and optimization.
  • Create and maintain data dictionaries and metadata repositories.
  • Assist with database software evaluation and technology recommendations.
  • Ensure database environments comply with accessibility standards and support users experiencing accessibility-related issues.
  • Support ETL processes, data integration, reporting, and business intelligence initiatives.
  • Collaborate with technical and business teams to gather requirements and implement database solutions.

Required Experience & Skills:

  • 5+ years of database administration experience.
  • Strong knowledge of database management systems and data warehouse architectures.
  • Experience developing, implementing, and maintaining data warehouses and data marts.
  • Experience building and maintaining data dictionaries.
  • Proficiency with database access and application delivery tools.
  • Strong analytical, planning, and management reporting capabilities.
  • Excellent written and verbal communication skills.
  • Strong teamwork and interpersonal skills.
  • Experience solving complex technical problems.
  • Knowledge of benchmarking methodologies and performance analysis.
  • Experience with data warehouse modeling techniques including:
    • Star Schema
    • Snowflake Schema
    • Highly normalized data models
  • Experience with ETL tools such as:
    • Informatica
    • IBM WebSphere DataStage
    • Similar enterprise ETL platforms
  • Experience with enterprise databases such as:
    • Oracle
    • SQL Server
    • Teradata
    • Similar database technologies
  • Experience with business intelligence and reporting tools such as:
    • Business Objects
    • Cognos
    • Hyperion
    • MicroStrategy
    • Similar reporting platforms
  • Experience throughout the full data warehouse lifecycle:
    • Requirements gathering
    • Logical data modeling
    • Physical database design
    • Data sourcing
    • Data transformation
    • Data loading
    • SQL development
  • Reporting and end-user tools
    • Proven ability to work effectively with both technical and non-technical stakeholders.
    • Ability to manage multiple priorities simultaneously.

Preferred Qualifications:

  • Oracle Database administration experience.
  • SSRS (SQL Server Reporting Services) report development experience.
  • M204 database experience.

Experience Level:

  • 4–7 years of relevant database administration experience.
  • Works with limited supervision and exercises independent judgment.

Additional Notes:

  • Candidates may be subject to pre-employment security and background reviews.
  • Experience with database security, compliance, and critical infrastructure protection is highly valued.
  • Strong focus on data integrity, availability, performance, and disaster recovery preparedness.


Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com