- Actively work with database software support for raising support tickets and triaging outages.
- Implement/support automation for production deployment on database platform.
- Develop, build & maintain mission critical centralized database platform.
- Diagnose and troubleshoot database errors.
- Implement user /query log analysis and alerts.
- Will collaborate with heterogeneous user groups from data engineers to data scientists.
- Implement data encryption/decryption/masking policies to protect PII/PCI data.
- Demonstrated proficiency of index design, query plan optimization and analysis required.
- User security auditing.
- Create utilization and capacity plans.
- Tune the database to improve queries.
- Provide technical leadership, fosters a team environment, and provides mentorship and feedback to technical resources.
- Train users and answer questions.
- On-call responsibilities on rotational basis for database administration.
- Should be able to review project requests describing database user needs to estimate time and cost required to accomplish project.
- User management, Security management, performance management, High availability management, space management, and backup management of databases.
- Experience with database tools, such as: SSMS, Toad, and ER/Studio Data Modeler.
- Build and maintain secure, compliant data processing pipelines, tables, views, procedures, and datasets.
- Integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions and/or performing analysis.
- Use database management tools and other Azure services for availability and performance monitoring.
- Automate database administration tasks using SQL and shell scripts.
- Work with engineers in support of SSO authentication requirements.
- Managing sets of XML, JSON, and CSV from disparate sources.
- Interprets, identifies, and solves unique and meaningful problems.
- Leads technical contribution to requirements / story development conversations.
- Communicates complex findings in a structured and clear manner to a non-technical audience (written and verbal) including communication to leadership.
- Follows best practices and standards, identifies gaps, and suggests changes.
- Responsible for understanding environmental constraints and planning to mitigate.
- Works respectfully with all team members, both OneAmerica colleagues and vendor partner team members.
- Bachelor's Degree in computer science or a related discipline.
- Microsoft Certified: Azure Data Fundamentals a plus.
- Microsoft Certified: Azure Database Administrator Associate a plus.
- Snowpro Core Certification a plus.
- 3+ years of experience in system or application database administration, to include providing critical support for database operations.
- 3+ years of experience supporting databases running on Azure or AWS cloud.
- 3+ years of experience working on a relational database as an application DBA.
- Ability to migrate from on-premises databases to cloud-based databases.
- Knowledge of Snowflake a plus.
- Understanding of data ingestion, data transformation, and making data consumable.
- Superb communication and coaching skills with the ability to connect with members of the development teams.
- Ability to apply and influence best practices and sound database design principles on a relational database platform.
-
Cash Management Specialist
2 weeks ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Cash Management Specialist
1 week ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Staff Accountant
3 weeks ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Team Lead, Facilities and Maintenance
4 days ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Sr. Digital Marketing Manager
2 days ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Sound & Lights Stagehand - Full Time
1 week ago
Indiana Convention Center & Lucas Oil Stadium Indianapolis, United States Full timeJob Description · Job DescriptionThis position is a skilled, hourly position providing technical theatrical equipment set-up and tear down as well as support for events. Work will occur at both the Indiana Convention Center and Lucas Oil Stadium. DUTIES: · Hang drape, signs, soun ...
-
Royalty Accountant
2 weeks ago
Lids Locker room Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Database Administrator
3 weeks ago
Anchor Point Technology Resources Indianapolis, United StatesResponsibilities · • Responsible for the maintenance of production, test and development databases. · • Brings solid understanding of database administration. · • Supports development team from a database design and development perspective. · • Responsible for database administra ...
-
Staff Accountant
3 weeks ago
Lids Indianapolis, United StatesAbout Our Company · Lids Sports Group is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licens ...
-
Associate Developer
3 weeks ago
Lids Indianapolis, United States Full timeAbout Our Company · Lids Sports Group, operating within Lids Holdings, Inc. is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across North America, Europe, and Australia. Operating out of Indianapolis, IN, Lids retail ...
-
Sr. Buyer
3 weeks ago
Lids Indianapolis, United StatesAbout Our Company · Lids is the largest licensed sports retailer in North America, selling fan and fashion-oriented headwear and apparel across the US, Canada, Mexico, Europe, and Australia. Operating out of Indianapolis, IN, our retail stores offer officially licensed headwear a ...
-
Eligibility Specialist
2 days ago
DFR Indianapolis, IN, United States Full timeOverview: THIS POSITION IS LOCATED IN INDIANAPOLIS, IN (5610 Crawfordsville Road, Suite 500) Knowledge Services has an opportunity for individuals drawn to the social service industry with the FSSA/Division of Family Resources (DFR) as an Eligibility Specialist. This position is ...
-
lpn
1 week ago
Sevita Indianapolis, IN, United StatesMentor Community Services, a part of the Sevita family, provides community-based services for individuals with intellectual and developmental disabilities. Here we believe every person has the right to live well, and everyone deserves to have a fulfilling career. You'll join a mi ...
-
Dealers Wholesale Indianapolis, United StatesJob Description · Job DescriptionJob Summary · The Hollow Metal Buyer works collaboratively with vendors, as well as internal departments, to ensure the correct product is here on time. This opportunity requires an individual to be an organized, solutions-oriented problem solver, ...
-
Consumer Loan Specialist
1 day ago
Heights Finance Corporation Marion, United StatesOverview: · We service our communities by offering personal installment loans designed to help our customers get the money they need when they need it. The Consumer Loan Specialist assists both new and existing customers in the lending process. This position is a terrific opportu ...
-
Eligibility Assistant
1 week ago
knowledge services Noblesville, United StatesOverview · THIS POSITION IS LOCATED IN NOBLESVILLE, IN · Knowledge Services has a great opportunity for a strong customer service focused individual who wants to make a difference in their daily work life with the FSSA / Division of Family Resources (DFR) as an Eligibility Assis ...
-
Site Reliability Engineer
4 weeks ago
Openlane Carmel, United StatesWho We Are: · At OPENLANE we make wholesale easy so our customers can be more successful. We're a technology company building the world's most advanced-and uncomplicated-digital marketplace for used vehicles. · We're a data company helping customers buy and sell smarter with cl ...
-
Restaurant General Manager
4 weeks ago
Golden Corral Greenwood, United StatesOur franchise organization, TBD Foods, LLC dba Golden Corral, is currently seeking energetic, friendly individuals to join our team · At Golden Corral, we know that successful people are the foundation of our very successful company. We hire managers with the talent, integrity, ...
-
Server
4 weeks ago
Golden Corral Greenwood, United StatesOur franchise organization, TBD Foods, LLC dba Golden Corral, is currently seeking energetic, friendly individuals to join our team · The main responsibility of the Server is "Making Pleasurable Dining Affordable." Fulfilling Golden Corral's mission statement requires a positive ...
-
Caregiver
1 week ago
Sevita Bargersville, United StatesMentor Community Services, a part of the Sevita family, provides community-based services for individuals with intellectual and developmental disabilities. Here we believe every person has the right to live well, and everyone deserves to have a fulfilling career. You'll join a mi ...
Application DBA - Indianapolis, United States - American United Life Ins Co
Description
Job Description
Job DescriptionAt OneAmerica Financial, we deliver on promises when customers need us most. We believe the best way to serve our customers is to know that every individual, employee, family and business we work with has unique personal and financial goals. We keep our promises, so we can help them achieve their goals and realize their definition of financial success.
Job Summary
The Data Delivery Team at One America is seeking an experienced Application DBA who is looking to join a fast paced and growing team focused on managing and strengthening the database environment. The ideal candidate should have a desire to leverage and build on their application DBA knowledge to improve and enhance One America's shared database environment.
The Application DBA will play a central critical role for identifying performing core database administration for the SQL Server and Snowflake environments, build automation to optimize the environment, build performance improvement plans, and be the central point of contact for application DBA work within the organization.
The role involves logical database design, reporting and the ongoing support and administration of databases, data marts, and warehouses. The role is responsible for writing and debugging complex SQL and understands the best ways to incorporate database requests into application programs. The role is deeply involved in requirements definition, design, development, deployment, maintenance, and enhancement of a variety of database structures.
The position will play a primary role in multiple projects, simple to challenging, with small to very large and complex SQL Server implementations. The application DBA will play an integral role in the development of analytics to measure performance and other areas of the data platform. This position requires a positive attitude and the ability to remain flexible in a dynamic and fluid environment.
Primary responsibilities include, but are not limited to:
Job Requirements
Required Education and/or Certifications
Recommended Education and/or Certifications
Required Work Experience
Salary Band: 05C
This selected candidate will be expected to work hybrid in Indianapolis, IN. The candidate will also be expected to physically return to the office in CA, IN or ME as business needs dictate or for team-building and collaboration.
If you are offered and accept this position, please be advised that OneAmerica does not have any offices located in the State of New York and OneAmerica associates are not permitted to work remotely in the State of New York.
Disclaimer: OneAmerica is an equal opportunity employer and strictly prohibits unlawful discrimination based upon an individual's race, color, religion, gender, sexual orientation, gender identity/expression, national origin/ancestry, age, mental/physical disability, medical condition, marital status, veteran status, or any other characteristic protected by law.
For all positions:
Because this position is regulated by the Violent Crime Control and Law Enforcement Act, if an offer is made, applicants must undergo mandated background checks as a condition of employment. Such background checks include criminal history. A conviction is not necessarily an absolute bar to employment. Consistent with applicable regulatory guidelines and law, factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered.
To learn more about our products, services, and the companies of OneAmerica, visit