Infrastructure DBA

Mid / Senior

|

Hybrid

Meytier Premier Employer

Apply NowAppliedThis job might no longer be active.

Working there

{"group":"Organization","title":"Infrastructure DBA","zohoId":"557706000004726023","endDate":"2020-10-08T00:00:00.000Z","jobType":"Full Time","job_url":"126-ascendum-infrastructure-dba","agencyId":1,"location":[{"lat":39.1,"lon":-84.5125,"city":"Cincinnati","text":"Cincinnati, OH 45201, USA","state":"Ohio","country":"","zipCode":"45201","is_state":false,"is_country":false,"state_code":"OH","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"842a931ffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":null,"minSalary":null,"startDate":"2020-09-21T00:00:00.000Z","onBehalfOf":"147","description":"<span id=\"spandesc\"><h1 style=\"margin: 0px; padding: 0px; text-align: justify\" class=\"align-justify\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Key Responsibilities:</span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></h1><ul style=\"orphans: 2; text-indent: 0px; widows: 2\"><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Participate in the maintenance, planning, and development of SQL Server technologies as well as NOSQL technologies such as MongoDB</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Proactively working on design and optimization of SQL and NOSQL databases</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Familiarity with Microsoft SQL Server versions 2012, 2014, 2016, 2017</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Familiarity with MongoDB</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">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</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Monitoring and troubleshooting database jobs and ETL/data loads and proactive resolution of issues to ensure maximum up-time/availability of application</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Performing routine database administration activities including setup login credentials for users &amp; administer general security measures on database, to resolve and troubleshoot database access/other database issues</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Develop and support cloud Data Warehousing and Business Intelligence platforms. The data warehousing platforms being utilized are SQL server and Snowflake hosted at Azure.</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Build database schema, tables, procedures and users/user access levels for each segment of database including modifying existing databases and database management systems.</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Setup database for appropriate data sharing and disk partitioning, test programs or databases, correct errors and make necessary modifications.</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Oversee backup, clustering, replication and failover (Always On Groups).</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Implement security and encryption to the database and data source files to safeguard information against accidental or unauthorized use, modification or disclosure.</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Perform administration, maintenance, monitoring and security tasks ensuring our database infrastructure is running efficiently and smoothly.</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Create scripts to provide monitoring, reporting, call services and execute jobs, automation</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"MsoListBullet align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Troubleshoot SQL processes and jobs such as CDC, extracts, scheduler, stored procedures</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li></ul><h1 style=\"margin: 0px; padding: 0px; text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Skills and Qualification:</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></h1><ul style=\"orphans: 2; text-indent: 0px; widows: 2\"><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Strong Experience in SSRS, T-SQL</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience setting up EDW in cloud environment</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Familiarity with database tools (IDERA, SSMS)</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience in SQL Backups and restores</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience identifying and resolving blocking issues</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Performance tuning and query optimization</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Trouble shooting in clustered environments (AG)</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">MS SQL server security and database permissions</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Migration and upgrades of SQL Server instances</span></span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience working with Windows server</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Ability to organize and plan work independently</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Experience with secure environments and compliance (HIPAA)</span></span></span></span><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\"><br /></span></span></li><li style=\"text-align: justify\" class=\"align-justify\"><span style=\"\"><span style=\"\"><span class=\"font\" style=\"font-family: verdana, sans-serif\"><span class=\"size\" style=\"font-size: 13px\">Ability to organize and plan work independently</span></span></span></span><br /></li></ul><div class=\"align-justify\" style=\"text-align: justify\"><br /></div></span><br />","isHybridJob":true,"isRemoteJob":false,"noOfOpenings":1,"maxExperience":"10","minExperience":"7","isOnPremiseJob":false,"onBehalfOfName":"Ascendum","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Mid / Senior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000004726023-1"]},"otherJobReference":null,"sharpenedJobTitle":"Infrastructure DBA","job_category_group":3,"portalLocationDisplay":"Cincinnati OH","expertise_coreskill_or_product":["Other"],"job_id":"2260"}