Oracle Sql Server Database Administrator Job at Blossom Tech Solutions, Baltimore, MD

bVpoSlNITWVMNEpRZXh5ajlmS1NZSVg0SVE9PQ==
  • Blossom Tech Solutions
  • Baltimore, MD

Job Description

Oracle/SQL Server Database Management Specialist (Senior)

Location: Baltimore, MD

Duration: FullTime

Client: MDOT SHA

Minimum Certification Requirements

SEND PDF copy of Certificate

A. Oracle Certified Professional (OCP) Certification.

At least one of the following certifications:

A. Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014

B. Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration

C. Microsoft Certified Solutions Associate (MCSA): Database Development

D. Microsoft Certified Solutions Associate (MCSA): BI Development

E. Microsoft Certified Solutions Associate (MCSA): Machine Learning

F. Microsoft Certified Solutions Associate (MCSA): BI Reporting

G. Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure

Minimum Experience Requirements:

  • At least Six (6) years of experience in DBMS systems analysis and programming.
  • Four (4) years of experience deploying software installations and upgrades for Oracle 11g / 12c Release 1 on a Windows OS environment.
  • Four (4) years of experience deploying software installations and upgrades for Oracle 11g / 12c Release 1 on a Oracle Linux OS environment.
  • Two (2) years of experience deploying software installations and upgrades for Oracle 19c / 12c Release 1 on a Windows OS environment.
  • Two (2) years of experience deploying software installations and upgrades for Oracle 19c / 12c Release 1 on a Oracle Linux OS environment.
  • Four (4) years of experience creating scripts for backing up data.
  • Four (4) years of experience deploying applications that utilize Oracle Connection Manager.
  • Four (4) years of experience configuring OEM tools and Oracle Grid Management Server.
  • Four (4) years of experience creating database backups and recovery.
  • Three (3) years of experience configuring RMAN for database backup and repository maintenance.
  • Three (3) years of experience configuring SMTP.
  • Four (4) years of experience deploying and configuring Oracle Data Guard on Windows OS.
  • Three (3) years of experience configuring Quest TOAD DBA SUITE for Oracle.
  • Three (3) years of experience configuring Quest SPOTLIGHT ON ORACLE RAC.
  • Two (2) years of experience configuring data integration scripts with TALEND.
  • Two (2) years of experience deploying and configuring Microsoft SQL Server 2016.
  • One (1) year of experience deploying and configuring SQL Server Reporting Services (SSRS).
  • At least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems and experience with DBMS internals.
  • Must be capable of providing highly technical expertise and support in the use of DBMS. Must be able to evaluate and recommend available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. Develops, implements, and maintains database back-up and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
  • Respond to critical trouble reports encountered after regular business hours by Network On-Call Personnel.
  • Respond to trouble reports or change requests (TR / CR Log) encountered by business users that are reported through Maximo Automated Help Desk Application.
  • Provide technical expertise and advice to staff and management.
  • Assist the Project Manager and Business Analyst in the preparation of documentation to describe new or changed processes.
  • Conduct training of staff and/or end users, as needed.
  • Attend organizational meetings as directed.

Primary Functional Responsibilities:

Server Configuration:

  • Install database software and create the database.
  • Determine and set sizing parameters for database structures.
  • Strip data files across multiple physical/virtual devices and locations.
  • Configure the database environment to support optimal data access performance.
  • Create and manage database configuration files and table spaces.
  • Create and manage multiple network configuration files.
  • Configure the database instance to support shared server connections.
  • Set up network tracing.
  • Configure the network environment to allow connections to multiple databases.
  • Ensure servers are current with SQL Server, Oracle and/or Windows security updates.
  • Configure FTP, WSFTP and scripting to send and receive files.

Database Security Administration:

  • Ensure servers are current with SQL Server, Oracle and Windows security updates.
  • Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by security standards/policies.
  • Document various security procedures in place to provide system security. Provide access to this document only to authorized personnel.
  • Define and Implement Security Policy.
  • Configure Database Fine Grained Auditing.
  • Use encryption toolkits to encrypt sensitive information.
  • Configure RMAN encrypted backups.
  • Set up Oracle Database, Listener & Connection Manager Security.
  • Use Application Context for Authentication and Authorization.
  • Configure LDAP and Active Directory Authentication using Enterprise User Security.
  • Monitor and manage Audit Trail.
  • Enforce security policies on database.
  • Implement VPD (Virtual Private Database) and data masking strategies to hide sensitive data.
  • Ensure Security Hardening at each level (OS/database/network).
  • Check OS Event Logs, SQL Server Logs, Oracle Logs and Security Logs for unusual events.

Oracle Administration:

  • Administer RAC
  • Administer Data Guard
  • Administer Enterprise Manager Grid Control
  • Manage Database Availability and Recovery
  • Administer Data Management
  • Administer Performance Management

Microsoft SQL Server Administration:

  • Ensure servers and databases are current with SQL Server patches and security updates.
  • Administer SQL Server and SQL Clustering.
  • Configure and monitor backups, restoration of databases.
  • Set up Alerts for Backup jobs.
  • Verify that all scheduled jobs are running successfully.
  • Create and administer new databases and manage database users, roles and security.
  • Monitor data and transaction log file growth.
  • Resolve user issues and coordination with application vendors.
  • Monitor OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
  • Create test SQL environment.
  • Install, Configure & Upgrade SQL Server.
  • Install SQL Server Service Packs (exp. SP2 and SP3).
  • Monitor disk space, memory configuration and server performance using System Monitor, Profiler, DMVs (Dynamic Management Views), or the SQL Server 2008/2010 Performance tuning advisor.
  • Use Management Studio or Profiler to help monitor and identify blocking issues.
  • Create SQL Server alerts for notification of potential problems.
  • Monitor MDF (Master Data File) and LDF (Log Data File) file growth and adjust if required.
  • Configure database jobs.
  • Set up and configure SQL Server Reporting Services.

TALEND Administration:

  • Install, configure and setup of TALEND Enterprise Data Integration server.
  • Install, configure and setup of TALEND Enterprise Data Integration Failover server.
  • Establish Project Categorization
  • Establish TALEND Project.
  • Establish TALEND Job Design.
  • Establish TALEND Metadata to be used / captured.
  • Set up SVN (Server Virtual Name) Repository Configuration.
  • Configure LDAP settings.
  • Set up and configure SVN Backup procedures.
  • Set up, configure and create data integration projects and jobs.
  • Schedule data integration projects and jobs in TALEND scheduler.

Database Monitoring Tool Administration:

  • Configure and use Spotlight tool to monitor the databases and TOAD, SQL developer for advanced coding.
  • Provide data modeling using tools ERWIN and TOAD Data Modeler.
  • Conduct load testing using tools like Swing Bench and TOAD Bench Mark Factory.
  • Configure and use Oracle Total Recall and Oracle System Monitoring Plug-in for Microsoft SQL Server to enable history tracking and compliance auditing

New Technologies Investigation:

  • Research, lab test, document and make recommendations to the TO Manager on a variety of new database related technologies that could be implemented and provide recommendations about the migration and upgrade paths for various systems.
  • Coordinate the installation and implementation of database management system software and related software tools with contractors, other data processing staff and system users.
  • Develop and implement new database management policies, procedures and standards

Please share update resume to praveen@blossomsolutions.net

Job Tags

Full time, For contractors, Remote job,

Similar Jobs

TBG | The Bachrach Group

Real Estate Closer Job at TBG | The Bachrach Group

 ...Our client, a large, national real estate company is continuing to grow and has an immediate need for a residential closer (multiple positions). A successful candidate will have direct experience in a client facing role at a law firm attending closings and performing them... 

Byler Holdings LLC

Byler Quarries General Manager Job at Byler Holdings LLC

The ideal candidate will have experience leading a team and managing the daily operation of the quarry. The general manager is responsible for the direction and overall financial performance of Byler Quarries stone crushing and hot mix asphalt operations. Responsibilities...

CoxHealth

Family Medicine Faculty Physician - Family Medicine Residency Program Job at CoxHealth

 ...Position Overview: CoxHealth is seeking a full-time, board-certified Family Medicine Physician to join the Family Medicine Residency Program as a faculty member. This well-established, community-based 10-10-10 residency program operates across two clinic sites and is... 

Insight Global

Recruiter Job at Insight Global

 ...Job Title: Recruiter Job Type: 4-5 month Contract (possible extensions) Location: Goodlettsville, TN - Hybrid...  ...their team for 5 months. The role require you to work onsite 4 days a week, allowing one remote day at home. This is a high-volume, fast-paced recruiting role... 

FARM Rio

Full-Time Stockroom Associate Job at FARM Rio

 ...all shipping/receiving tasks in an efficient, cost-effective, and timely manner Quality control on all products Control product stock level Assisting in the preparation and execution of the stores physical inventory Resolving inventory discrepancies,...