Database Engineer

3 weeks ago


Alpharetta, United States Cloudious LLC Full time
Job DescriptionJob Description

Qualifications:

  • 4 - 6+ years technical expertise in database and ETL development with Microsoft SQL Server technologies primarily T-SQL and SSIS.
  • Extensive development experience in analysis, modelling, and design of database solutions.
  • Integration Services, ETL and BI tools
  • Possess strong database fundamentals and experience in writing Unit test cases and test scenarios
  • Technical understanding of network, PC, and platform operating systems, including Microsoft Windows Server 2008 through current version.
  • Application development understanding of Microsoft .NET technologies primarily Powershell scripting, ASP.NET and C#.
  • Technical understanding of the different phases of the Software Development Life Cycle (SDLC) including waterfall and agile methodologies.
  • Understanding and technical knowledge of cloud-based technologies.
  • Have a grasp of SQL Server High Availability Solutions including Always On, Database Mirroring and Log Shipping concepts.
  • Able to effectively communicate verbally and in writing; in large meeting settings and when presenting to large groups; in both technical and non-technical arenas.
  • Able to understand and convey technical issues to non-technical associates, and vice-versa.
  • Able to develop and maintain effective working relationships across enterprise level lines.
  • Able to identify issues warranting escalation.

Key Responsibilities:

1. Database Design & Architecture:

  • Design and implement database solutions to support digital project requirements.
  • Create data models, schemas, and entity-relationship diagrams to represent data structures.
  • Ensure database designs meet performance, scalability, and security requirements.

2. Database Development & Optimization:

  • Perform extensive analysis of database entities, relationships and attributes.
  • Design and develop ETL (Extract, Transform and Load) processes using Transact-SQL (T-SQL) and Microsoft SQL Server Integration Services (SSIS).
  • Optimize ETL processes and T-SQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
  • Participate in both data design and data processing sessions for assigned projects and teams.
  • Create migration/conversion designs that meet the project's business, system and data requirements.
  • Create written data migration/conversion plans and data file/data model specifications that meet the project's business, system and data requirements.
  • Reverse engineer existing migration/conversion processes and data models including designing and utilizing Microsoft SQL Server Profiler traces.
  • Research and review data for presentation, accuracy and compliance within the business/system needs.
  • Review with team members/client and other database engineers the content, accuracy and completeness of data models, file specifications and migration/conversion processes.
  • Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes.
  • Respond to data design and/or data processing problems and find solutions in a timely manner.
  • Identify appropriate resources and work with them to research and resolve any open data-related issues.
  • Mentor staff by reviewing deliverables and offering team assistance whenever needed.
  • Possesses a deep knowledge of both the product and the technology; use both to design/architect business solutions.

3. Data Integration & Migration:

  • Support data integration between different systems and platforms involved in digital projects.
  • Plan and execute data migrations, ensuring data integrity and minimal downtime.
  • Collaborate with software engineers to integrate databases with applications.

4. Security & Compliance:

  • Support in database security measures, including access controls, encryption, and auditing.
  • Ensure compliance with data protection regulations and company policies.
  • Conduct regular security assessments and address vulnerabilities promptly.

5. Database Administration & Maintenance:

  • Perform routine database maintenance tasks, such as backups, restores, and updates.
  • Monitor database health, including disk usage, memory, and CPU utilization.
  • Automate repetitive tasks and develop scripts for database management.

6. Collaboration & Support:

  • Work closely with project managers, software engineers, and other stakeholders to understand database requirements and constraints.
  • Provide technical support and guidance during project implementation and post-launch phases.
  • Participate in code reviews, design discussions, and project planning sessions.

7. Documentation & Reporting:

  • Maintain comprehensive documentation for database designs, configurations, and processes.
  • Prepare reports on database performance, capacity planning, and future growth projections.
  • Document best practices and lessons learned from each project.

  • Database Engineer

    2 weeks ago


    Alpharetta, United States Zealogics.com Full time

    Job DescriptionJob DescriptionGeneral Database Engineer Duties and Responsibilities- Provide guidance and support to Application Developers- Assist with schema design, code review, SQL query tuning- Install, tune, implement and upgrade DBMS installations- Write and deploy SQL patches- Upgrade and improve application schema and data upgrades- Process work...

  • Database Engineer

    6 days ago


    Alpharetta, United States Zealogics.com Full time

    Job DescriptionJob DescriptionGeneral Database Engineer Duties and Responsibilities- Provide guidance and support to Application team- Install, tune, implement and upgrade DBMS installations- Write and deploy SQL patches- Process work accurately and in a timely manner- Always paying attention to the detail- Urgency- Proactively and regularly make...

  • Database Engineer

    3 days ago


    Alpharetta, United States Pinnacle Group, Inc. Full time

    About the Role:Pinnacle Group, Inc. is seeking a highly skilled Database Engineer to join our team. As a Database Engineer, you will be responsible for designing, implementing, and maintaining databases to support our business operations.Key Responsibilities:Database Design and Implementation: Design and implement databases to meet business requirements,...

  • Database Engineer

    4 days ago


    Alpharetta, United States Investment Bank Full time

    Description:Hybrid 2-3 days a week onsite and NO Database DeveloperLooking for : SAP ASE/Sybase, SAP Rep Server, Oracle, Redis , Postgres, Cassandra, Scripting ( Ansible,Python,Shell) ,Linux(must)General Database Engineer Duties and Responsibilities- Provide guidance and support to Application team- Install, tune, implement and upgrade DBMS installations-...

  • Database Engineer

    4 days ago


    Alpharetta, United States Investment Bank Full time

    Description:Hybrid 2-3 days a week onsite and NO Database DeveloperLooking for : SAP ASE/Sybase, SAP Rep Server, Oracle, Redis , Postgres, Cassandra, Scripting ( Ansible,Python,Shell) ,Linux(must)General Database Engineer Duties and Responsibilities- Provide guidance and support to Application team- Install, tune, implement and upgrade DBMS installations-...


  • Alpharetta, Georgia, United States InfiCare Technologies Full time

    Job DescriptionRole: Database Developer/EngineerLocation: Remote (Flexible Work Arrangement)Duration: Full TimeKey Responsibilities:Provide BAU support for the application, including investigation of business logic in PL/SQL.Raise release tickets and coordinate with various teams for database patches on weekends.Migrate the application to AWS/RDS.Perform...

  • Database Admin

    6 days ago


    Alpharetta, United States Russell Tobin & Associates Full time

    What are we looking for in our Database Admin? DBA - (Sybase / SAP ASE)12 Months Contract$60 - 70 /hr. W2Alpharetta, GA (Hybrid) Job Description: Hybrid 2-3 days a week onsite General Database Engineer Duties and Responsibilities Provide guidance and support to Application team Install, tune, implement and upgrade DBMS...


  • Alpharetta, United States Russell Tobin Full time

    DBA - (Sybase / SAP ASE)12 Months Contract$60 - 70 /hr. W2Alpharetta, GA (Hybrid)Job Description: Hybrid 2-3 days a week onsite General Database Engineer Duties and ResponsibilitiesProvide guidance and support to Application teamInstall, tune, implement and upgrade DBMS installationsWrite and deploy SQL patchesProcess works accurately and in a timely...


  • Alpharetta, United States Russell Tobin Full time

    DBA - (Sybase / SAP ASE)12 Months Contract$60 - 70 /hr. W2Alpharetta, GA (Hybrid)Job Description: Hybrid 2-3 days a week onsite General Database Engineer Duties and ResponsibilitiesProvide guidance and support to Application teamInstall, tune, implement and upgrade DBMS installationsWrite and deploy SQL patchesProcess works accurately and in a timely...


  • Alpharetta, United States Eliassen Group Full time

    Our client, an industry leader in financial services and technology, has an excellent opportunity for a Database Administrator to work on a 12+month contract role. Work will be 100% remote on EST. The Database Administrator will Provide guidance and support to Application Developers. Assist with schema design, code review, SQL query tuning.This position is a...


  • Alpharetta, United States Eliassen Group Full time

    Our client, an industry leader in financial services and technology, has an excellent opportunity for a Database Administrator to work on a 12+month contract role. Work will be 100% remote on EST. The Database Administrator will Provide guidance and support to Application Developers. Assist with schema design, code review, SQL query tuning.This position is a...


  • Alpharetta, United States Pinnacle Group, Inc. Full time

    Oracle Database Administrator / Sybase Engineer / Database EngineerAlpharetta Georgia 30022 (Hybrid 2 to 3 days a week onsite.)More on DB Engineering side with some prior exp. Of DB Admin tooLinux is mustScripting – Shell or PythonManager is open for either Sybase Engineer or Oracle DBA w/ NoSQLPrefer – recent version of Sybase 16.0 or Oracle...


  • Alpharetta, United States Pinnacle Group, Inc. Full time

    Oracle Database Administrator / Sybase Engineer / Database EngineerAlpharetta Georgia 30022 (Hybrid 2 to 3 days a week onsite.)More on DB Engineering side with some prior exp. Of DB Admin tooLinux is mustScripting – Shell or PythonManager is open for either Sybase Engineer or Oracle DBA w/ NoSQLPrefer – recent version of Sybase 16.0 or Oracle...


  • Alpharetta, United States Net2Source Inc. Full time

    Job Title: Oracle Database AdministratorLocation: Alpharetta, GA. [Hybrid 2-3 days a week onsite]Duration: 12 Months (Possible extension or conversion based on performance)Description:General Database Engineer Duties and ResponsibilitiesProvide guidance and support to Application teamInstall, tune, implement and upgrade DBMS installationsWrite and deploy SQL...

  • Database Developer

    1 month ago


    Alpharetta, United States RTA US Full time

    Job DescriptionJob DescriptionRussell Tobin's client, a global leader in investment banking is seeking a Database Developer in Alpharetta, GAGlobal Banking & Ops Technology (GBOT) team is looking for a Database Programmer to join a technologically advanced team focusing on developing and enhancing the Lending applicationsThis role will require the...

  • Database Developer

    1 month ago


    Alpharetta, United States Russell Tobin & Associates Full time

    What are we looking for in our Database Developer? Russell Tobin's client, a global leader in investment banking is seeking a Database Developer in Alpharetta, GA Global Banking & Ops Technology (GBOT) team is looking for a Database Programmer to join a technologically advanced team focusing on developing and enhancing the Lending...

  • Database Architect

    2 days ago


    Alpharetta, United States Investment Bank Full time

    Job DescriptionWe are seeking a highly skilled Database Engineer to join our team at the Investment Bank. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure high performance, security, and reliability.Key Responsibilities:Design and implement new database systems,...


  • Alpharetta, United States Net2Source Inc. Full time

    Job Title: Oracle Database AdministratorLocation: Remote/HybridDuration: 12 Months (Possible extension or conversion based on performance)Job Description:Key Responsibilities:Provide guidance and support to Application teamInstall, tune, implement and upgrade DBMS installationsWrite and deploy SQL patchesProcess works accurately and in a timely mannerAlways...


  • Alpharetta, United States Zealogics.com Full time

    Job DescriptionJob DescriptionDescription:Database Platforms Services - Analytics team is looking for a proactive, enthusiastic, and knowledgeable individual who is a self-starter and is passionate about Engineering Database solutions.This position will be focused on building automation pipelines around database platforms (on-prem and cloud) which will...

  • Engineer

    2 weeks ago


    Alpharetta, United States Pinnacle Group, Inc. Full time

    Snowflake DBA/Engineer/Developer / ArchitectCan be fully remote.Preference to have candidate local to Alpharetta, Chicago, New York, New Jersey, or California MS offices.Job Description: Database Platforms Services Analytics team is looking for a proactive, enthusiastic, and knowledgeable individual who is a self-starter and is passionate about Engineering...