NorfolkRecruiter Since 2001
the smart solution for Norfolk jobs

Systems Architect

Company: UST Global
Location: Norfolk
Posted on: May 3, 2021

Job Description:

SQL DBA

Description:

UST Global is looking for a talented and creative SQL DBA resources for one of the leading healthcare providers in the United States. This is an excellent opportunity to work in a growing environment. The ideal candidate must have strong skills in DBA activities at the same time be able to put their creative hat in a problem-solving environment. Excellent written and verbal communication skills with the ability to collaborate effectively with domain experts and IT leadership team is key to be successful in this role.

Responsibilities:

As an SQL DBA you will be responsible for: -

* Determines database structural requirements by analyzing client operations; applications; and programming; reviewing objectives with clients; evaluating current systems; * Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions. * Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating; integrating; and installing new releases; completing maintenance; answering user questions. * Maintains database integrity through security; back-up; and recovery specifications. * Prepares users by conducting training. * Provides database support by coding utilities; responding to user questions; and resolving problems. * Responsible for T-SQL query tuning Responsible for database migrations and server upgrades. * Troubleshoot application slowness and performance issues. * And other routine Database Admin duties -: (Database Performance; Maintenance and Development to perform the following: ? Database management including backups; recovery and maintenance ? Analyzes and generation of all tables and index statistics ? Monitoring and resolving data lock issues ? Check all statistics related to memory; locks; I/O; database response time; wait events; top sessions and background processes ? On-Line Transaction Processing (OLTP) to capture; validate and store large amounts of transactions ? Create indexes to achieve critical dataset response time for time sensitive reports; etc)

Must have skills:

* Determines database structural requirements by analyzing client operations; applications; and programming; reviewing objectives with clients; evaluating current systems; * Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions. * Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating; integrating; and installing new releases; completing maintenance; answering user questions. * Maintains database integrity through security; back-up; and recovery specifications. * Prepares users by conducting training. * Provides database support by coding utilities; responding to user questions; and resolving problems. * Responsible for T-SQL query tuning Responsible for database migrations and server upgrades. * Troubleshoot application slowness and performance issues. * And other routine Database Admin duties -: (Database Performance; Maintenance and Development to perform the following: ? Database management including backups; recovery and maintenance ? Analyzes and generation of all tables and index statistics ? Monitoring and resolving data lock issues ? Check all statistics related to memory; locks; I/O; database response time; wait events; top sessions and background processes ? On-Line Transaction Processing (OLTP) to capture; validate and store large amounts of transactions ? Create indexes to achieve critical dataset response time for time sensitive reports; etc) * Expertise in configuring and maintaining RMAN catalog; configuring RMAN for tape backup (Knowledge on TSM/TDP would be added advantage) * Expertise in RMAN backup/recovery * Knowledge of SQL Backtrack would be an added advantage * Performance tuning (Identify performance issues; Query tuning; analyzing AWR & ADDM reports; Active session history; Explain/Execution plan analysis; Tracing and Tkprof; RAC performance issues) * Minimum of 6-7 years of Oracle database administrative experience with versions 8i; 9i; 10g; 11g * BS in Computer Science or equivalent experience required. * Excellent written; oral and interpersonal communication skills required. * Oracle DBA certification required. * RAC experience required * Flexibility to work on weekend and night shifts * Experience in handling the role of Escalation On-call DBA (Tier II or above) * Experience in leading a team of at least 5+ DBAs

Good to have skills:

* Excellent written and oral communication skills. * Knowledge on SQL server and related performance analysis tools. * Basic understanding and knowledge on document-oriented databases such as MongoDB. * Basic understanding on cloud infrastructure such as AWS and Azure * Location: * This position is based in Norfolk; VA. Relocation assistance will be provided by the company.

Keywords: UST Global, Norfolk , Systems Architect, Other , Norfolk, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Norfolk RSS job feeds