Senior MS Database Administrator

1 week ago

Springfield, Illinois, United States PayLink Direct Full time

** No Visa Sponsorship **

** Position requires excellent verbal and written communication skills **

Summary:

Mid Sized Financial Services company needs an MS SQL DBA to work within our IT department. Reporting to the Director of Applications, this candidate will assist in maintaining the internal databases for efficiency, performance, create ad-hoc reports and anticipate growth. Corporate office is located above Union Station but the position is remote with only occasional times coming to the office to meet with the team. Coming to the office isn't a standard routine.

Key Position Responsibilities:

  • MS SQL Server Database Administrator
  • Extensive TSQL experience, including query optimization
  • Create and maintain SSIS packages
  • Create and maintain SSRS reports, and SSRS subscriptions, and maintain SSRS server
  • Create and maintain SSAS cubes
  • Perform code reviews for SQL work from the developers and provide guidance on acceptable code practices
  • Effectively communicate and collaborate with team members to gather accurate requirements for new enhancements and application development
  • Maintain knowledge of best practices surrounding IT technology, processes & database / support,
  • Maintain database documentation regarding data standards and procedures
  • Maintain and manage, database and database-related source code repositories

Non Technical Requirements:

  • 6+ years Microsoft SQL Enterprise DBA experience is required
  • Experience as an SQL Developer
  • Experience working in smaller teams within a growing environment
  • Proven ability to independently manage tasks and priorities, accurately estimate work, and meet deadlines
  • Ability to work under minimal supervision in a fast-paced team environment
  • Strong problem-solving skills, detail-oriented, and self-motivated
  • Excellent verbal/written communication skills.
  • Strong analytical and design skills
  • Experience translating functional requirements into technical specifications
  • Ability to escalate issues for resolution

Technical Requirements:

  • Prior experience with backup strategies, clustering, log shipping, and DR testing
  • Prior experience with High Availability Failover clusters, SQL server/job monitoring.
  • Prior experience in performing software/patch updates to database server
  • Hands-on experience creating, modifying, and analyzing SQL and T-SQL statements
  • Proven knowledge of Stored Procedures, Tables, Views, Indexes, Keys
  • Understanding of database performance bottlenecks and ability to track them down. Use of Execution Plans and Optimizer is a must.
  • Prior experience with Visual Studio to create SSRS reports, SSIS packages, SSAS cubes
  • Prior experience with Microsoft Management studio
  • Hands-on experience with Microsoft SQL Server Enterprise version 2016 and above
  • Proven experience using MS SQL Server database design & T-SQL, with the ability to write stored procedures, user-defined functions & SQL queries
  • Competency in version control systems, such as Git or TFS, with at least 2+ years of experience.

Pluses:

  • Use of performance tools such as Idera
  • Experience with Azure DevOps
  • Experience with Power BI
  • Experience with AWS Aurora

MUST provide minimum salary requirements to be considered. Salary commensurate with experience.

  • Senior Database Administrator

    1 day ago

    Springfield, Illinois, United States tapwage Full time

    Founded in 1936, Roseburg Forest Products is a privately owned company and one of North America's leading producers of particleboard, medium density fiberboard and thermally fused laminates. Roseburg also manufactures softwood and hardwood plywood, lumber, LVL and I-joists. The company owns and sustainably manages more than 600,000 acres of timberland in...

  • Senior Database Administrator

    1 week ago

    Springfield, Illinois, United States Roseburg Forest Products Full time

    Founded in 1936, Roseburg Forest Products is a privately owned company and one of North America's leading producers of particleboard, medium density fiberboard and thermally fused laminates. Roseburg also manufactures softwood and hardwood plywood, lumber, LVL and I-joists. The company owns and sustainably manages more than 600,000 acres of timberland in...

  • Database Administrator

    1 week ago

    Springfield, Illinois, United States CoxHealth Full time

    Summary Best in Class Work Environment5x Modern Healthcare Best Places to workAmerica's Greatest Workplaces 2023 – NewsweekBest Employers for New Grads 2023- ForbesGreatest Workplace for Women Newsweek BenefitsRobust, fully customizable benefits package including Medical/Vision/Dental and moreNo cost eCare visitsEmployer-provided mental health services...

  • Reporting, Database and Software Developer

    1 week ago

    Springfield, Illinois, United States Center for Human Development Full time

    Posting Details Posted: April 23, 2024 Full-Time Locations Showing 1 location Corporate Office Corporate Office 332 Birnie Avenue Springfield, MA , USA Corporate Office Corporate Office 332 Birnie Avenue Springfield, MA , USA +0 more locations less locations Job Details Description The Reporting, Database, and Software Developer is...

  • Senior Subcontracts Administrator

    2 months ago

    Springfield, Illinois, United States ENSCO Inc. Full time

    ENSCO Inc. s Procurement Department manages all aspects of the company s subcontracts efforts for systems integration, research and development, and engineering programs in support of its U.S. Government, Commercial, and International Customers.The Senior Subcontracts Administrator shall perform responsibilities which include support of developing requests...

  • Senior PSOC Administrator

    2 days ago

    Springfield, Illinois, United States Chenega MIOS Full time

    Senior PSOC Administrator - VA Springfield, VA Join our Talent Network Chenega Agile Real-Time Solutions (CARS) C-CARS Company Job Title: Senior PSOC Administrator Clearance: TS/SCI Location: Springfield, VA FLSA Status: Exempt, Full Time, Regular Summary: PSOC Administrators provide 24x7x365 monitoring services of the customer IT enabled Mission Services...

  • Sr. Oracle Database Analyst

    4 weeks ago

    Springfield, Illinois, United States General Dynamics Information Technology Full time

    Req ID: RQ174795Type of Requisition: RegularClearance Level Must Be Able to Obtain: Top Secret SCI + PolygraphJob Family: Database Analysis/DesignSkills:Database Development,Database Optimization,Structured Query Language (SQL)Experience:15 + years of related experienceUS Citizenship Required:YesJob Description:Deliver insights to help our clients turn data...

  • Sr. Oracle Database Analyst

    1 month ago

    Springfield, Illinois, United States General Dynamics Information Technology Full time

    Req ID: RQ174795Type of Requisition: RegularClearance Level Must Be Able to Obtain: Top Secret SCI + PolygraphJob Family: Database Analysis/DesignSkills:Database Development,Database Optimization,Structured Query Language (SQL)Experience:15 + years of related experienceUS Citizenship Required:YesJob Description:Deliver insights to help our clients turn data...

  • Project Administrator

    1 week ago

    Springfield, Illinois, United States Konecranes Full time

    Employment type: Undefined term- Full-time/part-time position: Full time- Workplace Type: HybridProject Administrator -Springfield, OH:At Konecranes, we believe that great customer experience is built on the people behind the Konecranes name. Everything we do, we do with passion and drive. We believe diversity drives business success and is the foundation...

  • Finance Program Manager

    1 day ago

    Springfield, Illinois, United States Government Solutions Consulting Llc Full time

    Skills and Experience:Required:· Bachelor's Degree in Accounting, Finance, or a Business related field such as Economics.· Demonstrated specialized experience in building, monitoring and modifying financial and budget execution plans using MS Excel, MS Project and other finance databases.Desired:· Master's in Business Administration or related field.·...

  • Community Relations Director

    1 week ago

    Springfield, Illinois, United States Phoenix Senior Living Full time

    Job Type Full-timeDescriptionThe Bungalows at Chesterfield Village is seeking a Community Engagement Director to join their teamThe Community Engagement Director reports to the Executive DirectorPURPOSESales & Marketing | Community RelationsThe Community Engagement Director is responsible for hands on sales execution at the community level through generating...

  • Senior Reimbursement Data Analyst

    4 weeks ago

    Springfield, Illinois, United States Health New England Full time

    PurposeThe Senior Reimbursement Data Analyst prepares the financial and statistical analysis related to in/out-of-network providers within the Health New England's service areas. As a member of the Finance team, the Senior Reimbursement Data Analyst is responsible for building, supporting and ensuring data integrity in support of contract modeling. The...

  • Senior Reimbursement Data Analyst

    2 months ago

    Springfield, Illinois, United States Health New England Full time

    PurposeThe Senior Reimbursement Data Analyst prepares the financial and statistical analysis related to in/out-of-network providers within the Health New England's service areas. As a member of the Finance team, the Senior Reimbursement Data Analyst is responsible for building, supporting and ensuring data integrity in support of contract modeling. The...

  • Administrative Assistant State Farm Agent Team Member

    1 week ago

    Springfield, Illinois, United States State Farm Insurance Full time

    State Farm Insurance JobID: [Office Assistant / Receptionist] As an Administrative Assistant at State Farm Insurance, you'll: Assist with administrative tasks such as filing, data entry, and document preparation; Schedule and coordinate appointments and meetings; Answer and direct phone calls and emails; Maintain and update customer records and databases;...

  • Senior Application Developer

    1 week ago

    Springfield, Illinois, United States Missouri State University Full time

    Posting Details Position Information Position Title Senior Application Developer Work Location Springfield Campus Department Computer Svc-Applications HR Home DepartmentCOMPUTER SERVICESPay Grade 35 Proposed Salary $62,812/ann. Position only available to current, regular, full-time Missouri State University employees? No, Position is available to all...

  • Senior Developer

    2 months ago

    Springfield, Illinois, United States United Airlines Full time

    United's Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions. Our Values: At United Airlines, we believe that inclusion propels innovation and is the foundation of all that we do. Our Shared Purpose: "Connecting people. Uniting the...

  • Systems Administrator

    1 week ago

    Springfield, Illinois, United States Hope Full time

    SUMMARY Leads help desk operations by providing basic and Teir II customer support. Responsible for the administration of and reporting from the company's ticket system. Determines when to escalate tickets to outside consultants and works with consultants to maintain computers systems, network integrity, and the company's cybersecurity posture. WHAT YOU...

  • Practice Administrator

    4 weeks ago

    Springfield, Illinois, United States Vituity Full time

    Springfield, IL - Seeking Practice Administrator Everybody Has A Role to Play in Transforming Healthcare As a Practice Administrator, you play a critical role by providing direct, business operations support to our medical directors, site physician partners, advanced providers and scribe (when applicable) employees. At Vituity we know the impact you can...

  • Senior iOS Mobile Developer

    1 month ago

    Springfield, Illinois, United States United Airlines Full time

    Description - ExternalThere's never been a more exciting time to join United Airlines. We're on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in hundreds of...

  • Senior iOS Mobile Developer

    4 weeks ago

    Springfield, Illinois, United States United Airlines Full time

    Description - ExternalThere's never been a more exciting time to join United Airlines. We're on a path towards becoming the best airline in the history of aviation. Our shared purpose – Connecting People, Uniting the World – is about more than getting people from one place to another. It also means that as a global company that operates in hundreds of...