Infrastructure DBA
Full Time 7 - 10 yrs CincinnatiPosted 21 days ago
Meytier works directly with Ascendum to help them hire more great candidates like you.
Ascendum is an innovation focused technology services firm focused on solving business challenges for enterprises, including many Fortune 1000 companies.
Job Description

Key Responsibilities:

  • Participate in the maintenance, planning, and development of SQL Server technologies as well as NOSQL technologies such as MongoDB
  • Proactively working on design and optimization of SQL and NOSQL databases
  • Familiarity with Microsoft SQL Server versions 2012, 2014, 2016, 2017
  • Familiarity with MongoDB
  • Managing the database artifacts and providing subject matter expertise on best practices for creation, deployment and ongoing management of databases in a SAAS, reporting/BI environment
  • Monitoring and troubleshooting database jobs and ETL/data loads and proactive resolution of issues to ensure maximum up-time/availability of application
  • Performing routine database administration activities including setup login credentials for users & administer general security measures on database, to resolve and troubleshoot database access/other database issues
  • Develop and support cloud Data Warehousing and Business Intelligence platforms. The data warehousing platforms being utilized are SQL server and Snowflake hosted at Azure.
  • Build database schema, tables, procedures and users/user access levels for each segment of database including modifying existing databases and database management systems.
  • Setup database for appropriate data sharing and disk partitioning, test programs or databases, correct errors and make necessary modifications.
  • Oversee backup, clustering, replication and failover (Always On Groups).
  • Implement security and encryption to the database and data source files to safeguard information against accidental or unauthorized use, modification or disclosure.
  • Perform administration, maintenance, monitoring and security tasks ensuring our database infrastructure is running efficiently and smoothly.
  • Create scripts to provide monitoring, reporting, call services and execute jobs, automation
  • Troubleshoot SQL processes and jobs such as CDC, extracts, scheduler, stored procedures

Skills and Qualification:

  • Strong Experience in SSRS, T-SQL
  • Experience setting up EDW in cloud environment
  • Familiarity with database tools (IDERA, SSMS)
  • Experience in SQL Backups and restores
  • Experience identifying and resolving blocking issues
  • Performance tuning and query optimization
  • Trouble shooting in clustered environments (AG)
  • MS SQL server security and database permissions
  • Migration and upgrades of SQL Server instances
  • Experience working with Windows server
  • Ability to organize and plan work independently
  • Experience with secure environments and compliance (HIPAA)
  • Ability to organize and plan work independently

© 2020 Meytier - All Rights Reserved