Database Administrator

3 months ago

Dublin, United States Intelliswift Software Full time

Must Have skills:

5 + years of SQL DBA experience

Advanced SQL

Performance Tuning

Disaster Recovery (DR)

Replication

PostgreSQL

PL/pgSQL

Snowflake - Highly desired


Database Administrator

  • Dublin, California

Responsibilities

  • Work with a team of passionate data engineers and scientists to enable data mining, deep learning, statistical modeling, predictive analytics, machine learning, and NLP.
  • Knowledge and strong experience and understanding of database structures, theories, principles, and practices. Knowledge of Microsoft SQL Server/Snowflake.
  • Ability to demonstrate expertise in relational database administration including configuration, implementation, data modeling, maintenance, redundancy/HQ, security, troubleshooting/performance tuning, upgrades, database, data, and server migrations.
  • Ability to demonstrate expertise in configuring, implementing, and supporting high availability redundancy strategies on systems including replication, clustering, log shipping, and mirroring.
  • Ability to demonstrate expertise in relational database design and architectural principles and methodologies. Ability to demonstrate expertise with High Availability and Disaster Recovery options, planning and implementation for MSSQL Server.
  • Knowledge and understanding of, and experience with, server-client computing and relational database environments. Knowledge and experience with data management and data processing flowcharting techniques. Knowledge of reporting and query tools and practices. Ability to perform the essential functions of this position.
  • Support Month End/Year End Production Activities
  • Responsible for providing day-to-day support and maintenance for existing SQL databases that are under support.
  • Accountable for identifying and tracking all databases by function, owner and application that are business critical in an agreed upon central location.
  • Assist in the administration, management, and monitoring of all SQL database systems.
  • Accountable for proper backup and disaster recovery procedures and documentation.
  • Good understanding of Database Architecture, Performance tuning of databases, pro-actively Identify bottlenecks and resolve them quickly.
  • Work with developers on performance tuning, query optimization, index tuning
  • Actively work with developers to solve database/application issues without compromising database best practices and work with them to promote changes to production.
  • Support SQL database in external cloud and work with various cloud providers as required.
  • Rotate with other DBAs to be on call to quickly fix issues that arise in our production and non-production environments
  • Be part of a 24/7/365 on-call rotation


Qualifications

  • Bachelor's degree in Computer Science, Information Systems or related field.
  • 5 + years of SQL DBA experience
  • Robust Ops foundation - you're always thinking "What happens if this fails" when you build things.
  • Proficient in scripting and automation
  • Worked with Machine Learning experts and Data Scientists to enable self-service data ingestion, transformation, visualization, reporting and advanced analytics (machine learning, AI).
  • Strategic thinker and thrive operating in a broad scope, from conception through a continuous operation.
  • Large enterprise database performance tuning experience
  • Strong communication skills
  • Experience directing other DBAs
  • Advanced SQL and PL/pgSQL programming skills, including concepts such as Covering Indexes, Triggers, Functions, Stored Procedures Materialized Views, etc.
  • Experience with Snowflake or other BI applications
  • Strong technical expertise in ML, AI, data preferred; experience working closely with data engineers, data science, and product teams to launch data products
  • Subject matter expert in all aspects of Data Management, Data Analytics and Operations Management
  • This position is located at Dublin HQ

  • Database Administrator

    3 months ago

    Dublin, United States Intelliswift Software Full time

    Must Have skills:5 + years of SQL DBA experienceAdvanced SQLPerformance TuningDisaster Recovery (DR)ReplicationPostgreSQLPL/pgSQLSnowflake - Highly desiredDatabase AdministratorDublin, California Responsibilities Work with a team of passionate data engineers and scientists to enable data mining, deep learning, statistical modeling, predictive analytics,...

  • Mainframe DB2 Application Database Administrator

    1 week ago

    Dublin, Ohio, United States SysMind Tech Full time

    Job SummaryAs a seasoned Database Administrator for Mainframe DB2 Applications, you will be responsible for designing and optimizing physical database designs tailored for the DB2 ZOS/MAINFRAME database environment. You will work closely with various application teams to understand data needs and ensure data subsetting and masking using IBM Optim....

  • Mainframe DB2 Application Database Administrator

    3 weeks ago

    Dublin, Ohio, United States SysMind Tech Full time

    Job Title: Mainframe DB2 Application DBAAt SysMind Tech, we are seeking a highly skilled Mainframe DB2 Application DBA to join our team. As a key member of our database administration team, you will be responsible for designing and implementing physical database designs tailored for the DB2 ZOS/MAINFRAME database environment.Responsibilities:Design and...

  • Epicor ERP System Administrator

    2 weeks ago

    Dublin, Ohio, United States Creative Financial Staffing Full time

    Epicor ERP AdministratorWe are seeking an experienced Epicor ERP Administrator to join our client's IT department. The successful candidate will oversee all aspects of the Epicor Kinetic ERP System, including updates, reports, and process improvements.Key Responsibilities:Manage Epicor Kinetic ERP system, including patches and upgradesDevelop and maintain...

  • Benefits Administrator

    3 days ago

    Dublin, Texas, United States Quantum Health Full time

    About the RoleThe Benefits Coordinator is a key position within the Quantum Health Total Rewards team. This role plays a vital part in the daily administration of our employee benefits and wellness programs, ensuring compliance with benefits laws and guidelines.Key ResponsibilitiesAdminister various employee transactions related to employee group health...

  • Administrative Coordinator

    2 weeks ago

    Dublin, Ohio, United States Ability Matters Full time

    Job SummaryWe are seeking a highly skilled and detail-oriented Administrative Assistant to join our Housing North team at Ability Matters. As a key member of our team, you will be responsible for providing administrative support, data analysis, and software training to ensure the smooth operation of our services.Key ResponsibilitiesSchedule appointments,...

  • Epicor ERP System Administrator

    1 week ago

    Dublin, Ohio, United States Creative Financial Staffing Full time

    About the RoleWe are seeking an experienced Epicor ERP Administrator to oversee all aspects of the Epicor Kinetic ERP System, including updates, reports, and process improvements.Key ResponsibilitiesManage the Epicor Kinetic ERP system, including patches and upgradesDevelop and maintain dashboards, reports, and customizationsOversee BPMs, complex coding, and...

  • System Administrator

    1 month ago

    Dublin, Ohio, United States Diamond Cellar Holdings Full time

    About Diamond Cellar HoldingsDiamond Cellar Holdings is a family-owned company with a rich history in the jewelry industry. With a strong presence in Columbus, OH, Nashville, TN, and Tulsa, OK, we pride ourselves on delivering exceptional customer service and showcasing renowned brands.Job SummaryWe are seeking a highly skilled System Administrator to join...

  • Vice President of Finance and Administration

    2 weeks ago

    Dublin, Ohio, United States Roto Group LLC Full time

    Job SummaryWe are seeking a highly skilled and experienced Vice President of Finance and Administration to join our team at Roto Group LLC. As a key member of our leadership team, you will be responsible for overseeing the financial and administrative operations of the company, ensuring compliance with accounting policies and procedures, and mitigating risks...

  • System Administrator

    1 week ago

    Dublin, United States Diamond Cellar Holdings Full time

    Diamond Cellar, a family-owned company rich in history, has been a cornerstone of the jewelry industry in Columbus, OH, with additional locations in Nashville, TN, and Tulsa, OK. As one of the largest independent jewelry companies in the United States, we pride ourselves on delivering unparalleled customer service and showcasing some of the world's most...

  • System Administrator

    2 months ago

    Dublin, United States Diamond Cellar Holdings Full time

    Diamond Cellar, a family-owned company rich in history, has been a cornerstone of the jewelry industry in Columbus, OH, with additional locations in Nashville, TN, and Tulsa, OK. As one of the largest independent jewelry companies in the United States, we pride ourselves on delivering unparalleled customer service and showcasing some of the world's most...

  • System Administrator

    3 weeks ago

    Dublin, United States Diamond Cellar Holdings Full time

    Diamond Cellar, a family-owned company rich in history, has been a cornerstone of the jewelry industry in Columbus, OH, with additional locations in Nashville, TN, and Tulsa, OK. As one of the largest independent jewelry companies in the United States, we pride ourselves on delivering unparalleled customer service and showcasing some of the world's most...

  • System Administrator

    2 months ago

    Dublin, United States Diamond Cellar Holdings Full time

    Diamond Cellar, a family-owned company rich in history, has been a cornerstone of the jewelry industry in Columbus, OH, with additional locations in Nashville, TN, and Tulsa, OK. As one of the largest independent jewelry companies in the United States, we pride ourselves on delivering unparalleled customer service and showcasing some of the world's most...

  • Vice President of Finance and Administration

    3 days ago

    Dublin, Ohio, United States Roto Group LLC Full time

    Job DescriptionRoto Group LLC is seeking a highly skilled and experienced Vice President of Finance and Administration to join our team. As a key member of our leadership team, this individual will be responsible for overseeing the financial and administrative operations of the company, ensuring compliance with accounting policies and procedures, and...

  • Epicor ERP System Manager

    4 weeks ago

    Dublin, Ohio, United States Creative Financial Staffing Full time

    Epicor ERP Administrator OpportunityWe're seeking an experienced Epicor ERP Administrator to join our client's IT department. The successful candidate will oversee all aspects of the Epicor Kinetic ERP System, including updates, reports, and process improvements.Key Responsibilities:Manage the Epicor Kinetic ERP system, ensuring seamless operation and...

  • Sales Associate

    1 month ago

    Dublin, Ohio, United States GBS Corp Full time

    Job SummaryThis role is designed to provide a career path for the Sales Associate to advance to a Sales Account Executive. GBS Corp expects an employee to spend a minimum of one year as a Sales Associate with a Healthcare focus prior to advancing to a Sales Account Executive. The Sales Associate will spend time in Business Development, Outside Sales, Project...

  • SAP ABAP Developer

    2 weeks ago

    Dublin, Ohio, United States Diverse Lynx Full time

    SAP ABAP DeveloperWe are seeking a highly skilled SAP ABAP Developer to join our team at Diverse Lynx LLC. As a key member of our development team, you will be responsible for designing, developing, and implementing SAP ABAP applications for our clients.Key Responsibilities:Design and develop SAP ABAP applications for HANA and non-HANA environmentsWork on...

  • Sales Associate

    5 months ago

    Dublin, United States GBS Corp Full time

    **POSITION SUMMARY** This position is designed to create a career path for the Sales Associate to advance to a Sales Account Executive. GBS expects an employee (without prior sales experience) to spend a minimum of one year as a Sales Associate (SA) with a Healthcare focus prior to advancing to a Sales Account Executive. The SA will spend time in Business...

  • Front Desk Coordinator

    4 weeks ago

    Dublin, California, United States Bayside Solutions Full time

    Job Title: ReceptionistWe are seeking a highly skilled and experienced Receptionist to join our team at Bayside Solutions, Inc.Job Summary:The Receptionist will be responsible for providing exceptional customer service and administrative support to our clients and internal teams.Key Responsibilities:Provide warm and welcoming reception services to clients...

  • Event Coordinator

    3 days ago

    Dublin, Ohio, United States Event Horizon Dynamics Full time

    Event CoordinatorAt Event Horizon Dynamics, we're passionate about delivering exceptional events that leave a lasting impact. As an Event Coordinator, you'll play a crucial part in supporting the successful execution of our events. Your responsibilities will include collaborating with event managers in planning and executing events, including venue...