Database Administrator

1 month ago


Saint Paul, United States Augeo Affinity Marketing Full time
Job DescriptionJob DescriptionDescription:

Hello, we're Augeo--architects of enterprise engagement and loyalty platforms, delivering compelling experiences and fostering meaningful connections with employees, customers, members and channel partners across industries. We serve thousands of clients, including more than 70 of the top Fortune 500 companies, representing millions of end users. We are thought leaders and disruptors who think differently and creatively, built by entrepreneurs, operators and innovators.


At Augeo, we're passionate about providing an inclusive workplace that values diversity. Everyone is welcome, and our employees are comfortable bringing their authentic whole selves to work. Be you.


We work hard, we play hard-and most importantly, we care to our CORE about our teams and each other. We over-communicate around everything, especially while we are all connected virtually.


Summary

We are actively seeking a highly skilled Database Administrator (DBA) with expertise in SQL Server and a strong foundation in AWS cloud services. The ideal candidate will have a comprehensive understanding of SQL Server, proficiency in SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and knowledge of PostgreSQL. Additionally, experience with AWS services, including RDS, S3 buckets, EC2 instances, and familiarity with AWS Glue, is highly desirable.

Who You Are

Innovator: Bring ideas to the table, work hard, tell your story, and build new tech

Collaborator: Contribute to the team and help accomplish amazing things

Curious: Keep learning, keep implementing, and iterate


Responsibilities

1. SQL Server Database Administration:

  • Administer and optimize SQL Server databases hosted in the AWS cloud, ensuring peak performance, availability, and security.
  • Implement and maintain best practices for SQL Server deployments and configurations.

2. AWS Cloud Services:

  • Manage databases in AWS RDS, understanding the nuances of cloud-based database administration.
  • Utilize and configure AWS S3 buckets for scalable and secure data storage.
  • Work with EC2 instances as needed for specific database requirements.

3. Performance Tuning:

  • Develop and execute strategies for optimizing database and query performance.
  • Identify and resolve performance bottlenecks through meticulous tuning, indexing, and query optimization.

4. PostgreSQL Knowledge:

  • Leverage knowledge of PostgreSQL to enhance database management capabilities.
  • Provide expertise in PostgreSQL as needed, contributing to the overall versatility of the DBA team.

5. SSIS Development and Maintenance (Nice to have):

  • Design, develop, and maintain SSIS/GLUE packages for efficient data integration, transformation, and loading.
  • Troubleshoot and optimize SSIS workflows to enhance data flow and ETL processes.
  • Troubleshoot and optimize AWS Glue jobs, ensuring seamless data flow between various sources and destinations.

6. Security and Compliance:

  • Implement and enforce security protocols for SQL Server and AWS environments.
  • Ensure compliance with industry standards and regulations related to database security.

7. Documentation and Collaboration:

  • Maintain comprehensive documentation of database configurations, cloud services, and procedures.
  • Collaborate effectively with cross-functional teams, developers, and system administrators to support cloud-based applications and initiatives.

Competencies

  • Strong written and verbal communication skills, including technical writing skills
  • Fundamental analytical, conceptional thinking and problem-solving abilities
  • Ability to participate in meetings communicating findings and plans to cross-functional team members, management, and clients
  • Forward thinking on ways to improve product related challenges with an eye toward delivering value to the end user
  • Organized, with the ability to work independently toward project driven deadlines, in person or remote
  • Experience prioritizing initiatives based on internal and client business needs

Education and Experience

  • Two-year or four-year college degree from a regionally accredited college or university preferred
  • Proven experience as a SQL Server Database Administrator with a strong emphasis on AWS.
  • Experience in SSIS, SSRS, and Glue for ETL and reporting.
  • Familiarity with PostgreSQL is highly desirable.
  • Solid understanding of AWS RDS, S3, EC2, and Glue services.
  • Experience with performance tuning, indexing, and query optimization.
  • Excellent problem-solving skills and adaptability to a dynamic cloud environment.
  • Experience working in an Agile-based environment
  • Experience in a SOC 2 Type II certified environment
  • Experience working with JIRA and Confluence
  • Understanding of and discipline to follow rigorous IT data and systems policies
  • Ability to work on multiple assignments and achieve objectives and deadlines

Benefits

  • Medical, Dental & Vision Insurance
  • Employer-sponsored Long-term disability and Life Insurance
  • Paid Time Off and flexible work schedule
  • 401(k) Plan
  • Fun and casual work environment
  • Career growth opportunities
  • Rewards & Incentives
Requirements:




  • Saint Peters, United States CarShield Full time

    CarShield is a Best Place to Work, as voted by Glassdoor and the St. Louis Business Journal. We are growing fast and looking to add key talent to the team. We offer a competitive base compensation and benefits package, including medical, dental, vision, life, 401k, and discounted tuition at Lindenwood University!We believe in developing our people and...


  • Saint Peters, United States CarShield Full time

    CarShield is a Best Place to Work, as voted by Glassdoor and the St. Louis Business Journal. We are growing fast and looking to add key talent to the team. We offer a competitive base compensation and benefits package, including medical, dental, vision, life, 401k, and discounted tuition at Lindenwood University!We believe in developing our people and...


  • St Paul, United States Augeo Full time

    Job Type Full-time Description Hello, we're Augeo-architects of enterprise engagement and loyalty platforms, delivering compelling experiences and fostering meaningful connections with employees, customers, members and channel partners across industries. We serve thousands of clients, including more than 70 of the top Fortune 500 companies, representing...


  • City of Saint Peters, United States NRRM Full time

    Job DescriptionJob DescriptionCarShield is a Best Place to Work, as voted by Glassdoor and the St. Louis Business Journal. We are growing fast and looking to add key talent to the team. We offer a competitive base compensation and benefits package, including medical, dental, vision, life, 401k, and discounted tuition at Lindenwood University!We believe in...


  • Saint Paul, Minnesota, United States Department Of The Army Full time

    Summary About the Position: The office atmosphere is friendly, high functioning with staff from a variety of backgrounds. Incumbent performs a variety of administrative and technical support functions for the office. Must be competent in the use of Personal Computers (PCs) to maintain required databases, extract, and/or download data, and develop...


  • Saint Paul, United States Department Of The Army Full time

    Summary About the Position: The office atmosphere is friendly, high functioning with staff from a variety of backgrounds. Incumbent performs a variety of administrative and technical support functions for the office. Must be competent in the use of Personal Computers (PCs) to maintain...


  • Saint Paul, United States Sail Full time

    Job DescriptionJob DescriptionDescription:About UsOur passion is operating multifamily assets at peak performance. We believe in an all-encompassing, top-tier, and concierge-focused property management approach where all aspects of marketing and operations are performed with precision and result in the best possible outcome. We consider positive resident...

  • Grant Administrator

    3 days ago


    Saint Paul, Minnesota, United States Metropolitan Council Full time

    WHO WE ARE We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services. More information about us on our website. We are committed to supporting a diverse workforce that...

  • Grant Administrator

    13 hours ago


    Saint Paul, United States Metropolitan Council Full time

    WHO WE ARE We are the Metropolitan Council, the regional government for the seven-county Twin Cities metropolitan area. We plan 30 years ahead for the future of the metropolitan area and provide regional transportation, wastewater, and housing services. More information about us on our website. We are committed to supporting...


  • Saint Paul, United States Summit Companies Full time

    Job DescriptionJob DescriptionAre you interested in working for the nation’s leading fire protection company and beginning a rewarding and satisfying career that helps save the lives of thousands each year? Do you want to be a part of a growing and expanding team of industry experts? If so, exploring career opportunities with Summit Companies may be right...


  • Saint Paul, United States Great Clips Full time

    Applicants in the Minneapolis-St. Paul Metropolitan area only, please. This position is responsible for the timely and effective coordination of the legal and compliance activities related to franchising, including providing disclosure documents to franchisees in accordance with U.S. and Canadian laws, processing franchise and related legal agreements,...

  • TRANSCOM IGC

    2 days ago


    Saint Louis, United States IT Partners,Inc Full time

    Job DescriptionJob DescriptionThe DBA will design, implement and maintain the Oracle database as well as a Teradata Database that maintains historical data associated with the program. The DBA will manage access control and privileges, conduct validation checks, maintain security, manage documentation and ensure integrity of the data architecture....


  • Saint Paul, Minnesota, United States Lutheran Social Service of Minnesota Full time

    Note: Please include a cover letter when submitting your application for this position.Lutheran Social Service MN is a dynamic social service organization serving children, youth and families, people with disabilities, older adults and military veterans. Trustworthiness is a value and strength shared by our employees and recognized by the communities we...


  • Saint Paul, United States Capital Street Financial Services, Inc. Full time

    Job DescriptionJob DescriptionPosition Description:Full-time Front Desk Executive & Administrative Assistant to support a financial services firm in downtown St. Paul. Primary responsibilities include, but are not limited to, greeting clients upon arrival, answering and directing telephone calls, scheduling meetings, maintaining databases, document...


  • St Paul, United States Tata Consultancy Services Full time

    Job Title Hyperion Admin Work Location (State, City and Zip)Houston, US, Zip- 77079 Relevant Experience (in Yrs) 5+ years Must Have Technical/Functional Skills 1. Design, Installation, Configuration, Upgradation, Patching and Support of Oracle EPM 11.1.2.4 and Oracle EPM 11.2.x systems. 2. Administration and Infrastructure of Hyperion Foundation, Calculation...

  • Program Administrator

    4 weeks ago


    Saint Paul, United States Mitchell Hamline School of Law Full time

    Job DescriptionJob DescriptionPurpose:Mitchell Hamline School of Law is a leader in pedagogical innovation dedicated to expanding access to high-quality legal education and seeks a full-time Program Administrator to work with our Native American Law and Sovereignty Institute.The Program Administrator supports the activities and initiatives of the Native...


  • Saint Paul, United States Minnesota Assistance Council for Veterans Full time

    Job DescriptionJob DescriptionDescription:Organization Overview:Minnesota Assistance Council for Veterans (MACV) is a statewide nonprofit organization with a mission to end Veteran homelessness in Minnesota. MACV provides comprehensive programs in the areas of housing, employment, and legal services to support Veterans and their families throughout Minnesota...


  • Saint George, United States Forte Strong, INC Full time

    Job DescriptionJob DescriptionSummary of positionThe Admin Assistant is responsible for managing all aspects of client billing and collections using billing and tracking software, especially setting up and closing out accounts. They are responsible to pay bills, deposit checks, sort mail, respond to email, file paperwork, answer client’s billing questions,...


  • Saint Pauls, United States Addison Group Full time

    Job Requirements:Year(s) of Experience: 2-3 years of administrative/finance experienceEducation: HS/GED is required Additional: Be able to communicate in English via verbal and written communicationsModerate to high level of computer skills in MS Word, MS Excel, and MS OutlookSAP experience is a plusValid Driver’s LicenseComfortable with working on a...


  • Saint Paul, United States Mounds Park Academy Full time

    Job DescriptionJob DescriptionMounds Park Academy is a PreK-12 independent school in Saint Paul, MN that serves approximately 575 students from throughout the Twin Cities area. Since 1982, Mounds Park Academy has engaged students in a rigorous college preparatory experience that is demanding, but not draining, and goes far beyond memorization. Students are...