See more Collapse

AWS Redshift Database Administrator

2 months ago


McLean, United States Compunnel Full time
POSITION OVERVIEW :

Job Overview:

The AWS Redshift Database Administrator will be responsible for the maintenance, configuration, and reliable operation of our AWS Redshift databases.

This role involves monitoring database performance, implementing changes, and maintaining data security and integrity.

The ideal candidate has extensive experience with Redshift and other AWS services, strong problem-solving skills, and the ability to collaborate with development teams to optimize database usage and performance.

This position may require on-call availability and might require working during non-business hours and on weekends in case of emergencies or planned maintenance.

POSITION GENERAL DUTIES AND TASKS :

Responsibilities and Duties:

Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the company's AWS Redshift databases.

Monitor database performance, implement changes, and apply new patches and versions when required.

Perform and manage backup, recovery, and migration tasks.

Collaborate with data engineers and developers to optimize queries, data loads, and database schema design for maximum efficiency and performance.

Ensure that data replication, backup, and recovery processes are in place and functional to meet the company's disaster recovery and business continuity strategies.

Implement and maintain database security, create, and manage user accounts, and maintain system security under the guidelines of the company's IT Security Policy.

Troubleshoot and resolve database issues, perform database tuning and performance monitoring.

Prepare and maintain documentation and standards related to database administration.

Stay informed of new technologies and practices relevant to database administration and recommend innovative and where applicable, automated approaches for system administration tasks.

Qualifications:

Bachelors degree in computer science, Information Technology, or related field.

10+ years of experience as a Database Administrator, with at least 3 years focused on AWS Redshift.

Strong understanding of database structures, theories, principles, and practices.

Working technical experience with designing, building, installing, configuring, and supporting database servers, including AWS Redshift.

Experience with AWS services such as EC2, S3, IAM, EMR, and Lambda.

Proficient in SQL and experience with data migration, transformation, and scripting.

Knowledge of data privacy laws and understanding of managing sensitive data.

Excellent problem-solving and communication skills.

Preferred Skills:

AWS Certified Database - Specialty certification.

Experience with other database technologies (e.g., PostgreSQL, MySQL, Oracle).

Familiarity with data warehousing concepts and ETL processes.

Scripting skills (e.g., Python, Bash)

Education: Bachelors Degree

Additional client information:

We have other current jobs related to this field that you can find below


  • McLean, United States Collabera Full time

    Description Home Search Jobs Job Description Database Administrator Contract: McLean, Virginia, US Salary: $50.00 Per Hour Job Code: 351450 End Date: 2024-08-07 Days Left: 3 hours left Apply Job Title: Database Administrator Location: Remote Role Duration: 12+ Months Contract Role Pay Range: $45/hr to $50/hr Job Description: Execute tasks related to...


  • McLean, United States Collabera Full time

    Description Home Search Jobs Job Description Database Administrator Contract: McLean, Virginia, US Salary: $50.00 Per Hour Job Code: 351450 End Date: 2024-08-07 Days Left: 3 days, 3 hours left Apply Job Title: Database Administrator Location: Remote Role Duration: 12+ Months Contract Role Pay Range: $45/hr to $50/hr Job Description: Execute tasks...


  • McLean, United States Virpie Tech Full time

    Job Title: Database Administrator Location: Remote Duration: Long Term Client: Booz Allen / IRS BOLA Client is looking for a Database Architect . Experience with database administration using PostgreSQ. Experience with schema development DOML, JSON), data modeling, and data mapping. Knowledge of data replication, user administration, backup and recovery,...


  • McLean, United States United Software Group Inc Full time

    Job Title: Microstrategy Administrator with AWS (Remote)Location: McLean, VA (Remote)Position Overview:We are seeking a seasoned Microstrategy Administrator with AWS experience to join our team. This remote position will involve leading the administration and maintenance of MicroStrategy servers, ensuring optimal performance, and supporting a range of...


  • McLean, United States Torin Consulting, Inc. Full time

    Torin is looking for a qualified Database Administrator with demonstrated database engineering and administration of systems for complex and high volume data processing. The candidate will use a variety ingest methods and data management techniques. Management includes a variety of data types, database functionality, compliance standards and availability...


  • Mclean, United States NTT DATA Services Full time

    Req ID: 293932  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Microstrategy Administrator with AWS (Remote) to join our team in Mclean, Virginia (US-VA),...

  • Senior AWS Engineer

    2 weeks ago


    McLean, United States JobRialto Full time

    Description Responsibilities: Be part of a team that is responsible for managing operations of a large scale production application on AWS. The team manages the resiliency, monitoring, as well as the maintenance of the application. Get hands-on experience with several AWS services every day, whether they are managing resources via the AWS cli, console, or...


  • McLean, United States CapLeo Global Full time

    Position :: PostgreSQL & DB2 - Database Track Sr.Engineer Location :: McLean, VA (Day 1 Onsite 3 days Onsite 2 days Remote)Skill Needed:- PostgreSQL, DB2, AWS, Migration Must have 7+ years DBA working experience with PostgreSQL open source and good understanding of other RDBMS such as DB2 , Sybase, Oracle and MS SQL server. Experience in migrating Sybase /...


  • Mclean, United States Capital One Full time

    Plano 1 (31061), United States of America, Plano, TexasSenior Data Engineer (Python, Kafka, Databricks, AWS)Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative,inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers,...


  • McLean, United States RF Hiring Solutions Full time

    QUALIFICATIONS:Bachelor’s degree and/or equivalent experienceMinimum of 10 years of related experience of database engineering, delivery, and support.Ability to work across teams to create partnerships that achieve organization goals, and passionate about building an innovative culture.Ability to technically lead the cloud database technology team along...


  • McLean, United States RF Hiring Solutions Full time

    QUALIFICATIONS:Bachelor's degree and/or equivalent experienceMinimum of 10 years of related experience of database engineering, delivery, and support.Ability to work across teams to create partnerships that achieve organization goals, and passionate about building an innovative culture.Ability to technically lead the cloud database technology team along with...


  • McLean, United States RF Hiring Solutions Full time

    QUALIFICATIONS:Bachelor’s degree and/or equivalent experienceMinimum of 10 years of related experience of database engineering, delivery, and support.Ability to work across teams to create partnerships that achieve organization goals, and passionate about building an innovative culture.Ability to technically lead the cloud database technology team along...

  • Marketing Data Analyst

    3 months ago


    McLean, United States Technology Ventures Full time

    Data Scientist/Visualization - Objectives of this role • Building models to address business problems • Presenting information using data visualization techniques • Devise and utilize algorithms and models to mine big-data stores; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy • Analyze data for...

  • Data Engineer

    3 weeks ago


    McLean, United States Mindlance Full time

    We are seeking a skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will have a strong background in data engineering, with expertise in working with big data technologies such as Apache Spark, Python, Apache Flink, and AWS services. As a Data Engineer, you will be responsible for designing, building, and maintaining scalable...

  • Data Engineer

    3 weeks ago


    McLean, United States Mindlance Full time

    We are seeking a skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will have a strong background in data engineering, with expertise in working with big data technologies such as Apache Spark, Python, Apache Flink, and AWS services. As a Data Engineer, you will be responsible for designing, building, and maintaining scalable...


  • McLean, United States DMI Full time

    About DMI DMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation,...

  • Database Engineer

    2 months ago


    McLean, United States The Swift Group Full time

    Job DescriptionJob DescriptionThe Swift Group is looking for a Database Engineer. This candidate will lead the design, implementation and testing of a complex data infrastructure in support of our customer needs. This candidate will work with network, systems, and application engineers to manage the database engineering and administration of systems for...


  • Mclean, United States Cognizant Full time

    Cognizant is looking for an experienced and innovative Lead Java and Nodejs Developer w/AWS a to serve our diverse base of global clients. As a member of our team, you will build cutting edge, cloud-based software that powers modern business. An ideal candidate is someone who enjoys working in a diverse, collaborative, geographically distributed team....


  • McLean, United States Saxon Global Full time

    Job Description: Senior IICS/AWS Engineer Required Skills: * Strong hands-on experience building ETL pipelines and Data Replication * Hands-on experience with Informatica Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS), Cloud Data Integration (CDI) * Experience with monitoring and troubleshooting of tasks * Expertise in shell...


  • McLean, United States Saxon Global Full time

    CLOUD ENGINEER SENIOR (HYBRID WORK SCHEDULE) Job Description At our company, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. As part of the company's return to the office pilot, all employees, contingent...