Database Administrator

CapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We provide industry standard benefits, and an environment for LEARNING & Growth. For one of our going on project we are looking for a Database Administrator. The position is based out of Madison but can be done remote as of now WI. The Database Administrator primary responsibilities for standard maintenance and administration of Oracle and SQL databases. The DBA will collaborate with programmers and analysts to implement and validate changes to database schemas and supporting environments. The DBA should have experience with Oracle Database management tools such as OEM, SQL Plus, and SQL developer; Microsoft SQL Server management tools such as Management Studio. The primary responsibility will be the operational support of the existing databases. Responsibilities: 5 years experience to Database Tuning and Maintenance to assure highest level of system 5 years experience to Ability to navigate and query a relational database (Oracle) to both develop reports 5 years experience to Create database objects 3 years experience to Database design 5 years experience to Database links and multiple database instances 4 years experience to Database monitoring tools 5 years experience to Database security 3 years experience to Logical database design 4 years experience to Oracle; Knowledge of Oracle including stored procedures and SQL Tuning 3 years experience to Oracle 11g 2 years experience to Oracle 12c 5 years experience to Oracle database security, synonyms, roles, privileges 4 years experience to Oracle data dictionary views 2 years experience to Oracle PL/SQL unit testing 4 years experience to Oracle SQL tuning 2 years experience to PL / SQL 1-year experience to SQL SSAS 1-year experience to SQL SSIS 1-year experience to Informatica 2 years experience to Working knowledge of SQL Server T-SQL 1-year experience to Microsoft SQL Server Reporting Services.