*Face to Face Required*
*Location : **Massachusetts- Boston*
*Duration : 6+ Months*
*M.O.I : Phone and F2F*
*F2F IS MUST AFTER TELEPHONIC*
BEACON is a complex system with 9 full volume databases to support it.
These databases each require over 3 terabytes of data space. These
databases are either up or being maintained 24 hours per day.
This includes multiple lower and production environments as well as
disaster recovery (DR).
Prior to consolidation BEACON was supported by 5 full time DBAs.
The current DBA is assigned coverage as 24 by 7.
This involves daily data fixes to support routine operations. In addition
to the daily operational tasks the DBA is required to resolve database
issues such as missing triggers, any slow running queries, and all
performance related adhoc questions/issues as they may arise due to
infrastructure/network changes.
The databases need to have Oracle patches and upgrades applied routinely.
At present, we have been searching for a FTE resource to fill the position
of the DBA who resigned two years ago. We have been actively searching for
this vacancy for over 10 months.
Having a dedicated DBA as a U05 Contractor would ensure that we get strong
technical skillset from the competitive market and would alleviate the
strain on the 2 “shared” resources from the VG DBA team we are using to
fill the gap. These two borrowed resources are consistently working
overtime to sustain routine operations.
It’s been extremely challenging to continuously negotiate and request
additional time from these resources with competing priorities within the
various agencies.
As we continue our search for the dedicated FTE DBA, it would be highly
recommended that we hire a contractor to fill our immediate need.
*DBA Job Description*
The Executive Office of Health and Human Services is seeking an experienced
application DBA to support multiple development teams. The DBA must have
sold understanding and experience working with Oracle and various tools
that are used to support the environment. The DBA will serve as a lead and
provide guidance to developers as needed. The DBA will provide daily
operational support as well as special projects. The DBA will be
responsible for creating the necessary architecture and providing on call
support. Beyond the basic DBA roles of Regulatory Compliance Support, Team
Interface Support, Strategic Capacity Planning and Proof of Concept (POC )
Model Support in additional to providing DB Design / Logical Data Modeling,
Application DB Administration, SQL Support, DB Design / Physical Data
Modeling, Testing Support, Security Support, DR / Backup / Recovery -
Planning & Implementation, and Application Performance Monitoring and
Tuning.
This position includes 24 hour by 7 day per week support and will include
evenings and week-ends.
Responsibilities:
•Comply with federal and state laws as well as any policies, requirements,
or standards from EOHHS, individual agencies, our DBA teams, and ITD.
•Interface with management, database users, operations, systems
administration, vendors, and various support groups.
Tasks may include providing technology reviews and summaries, making
recommendations, and instructing staff in the best use of their databases.
•Perform database high level capacity planning, required for long term
procurements and implementation.
•Develop working Proof of Concept models when required
•Create DB Objects for Development and Test Databases only. As application
software migrates beyond the Test environment, provide database Object /
DDL scripts to the System DBA team to migrate those constructs to upper
environments. Perform database problem analysis and correction.
•Establish standards and best practices for SQL to be used by applications
teams. Interact with and coach developers in SQL scripting. Analyze data
access options and ensure efficient SQL are utilized.
•Provide DBA support (doing standard DBA tasks) to other teams that do
applications testing.
•Translate logical data models into a physical models, using performance
based denormalization, volumetrics, etc. to select appropriate storage
formats, structures, and hardware (e.g. servers, storage, networks,
etc.). This includes the effective use of indexes and enabling "Parallel
Query" execution or other DBMS specific features if appropriate.
Implementations should include any required auditing and timestamp columns
and other mechanisms required to satisfy requirements.
•Implement DBMS security - add / remove users and related access
permissions (not application security), administering quotas, auditing, and
checking for security problems. The formal source of all user
add/modify/drop permissions should be the application sponsor and security
team staff - the DBA teams should merely implement those decisions.
•Work with operations and systems admin teams to create backup and recovery
strategies for databases. Support those teams to help develop and
administer the disaster recovery plan (DR).
•Perform database performance monitoring and tuning, using automated
toolsets and manual inspections as needed. Take corrective actions when
appropriate.
•Perform database version updates as required for support from vendor.
•Working in conjunction with data architects he / she is responsible for:
using a formalized methodology, analyze information needs, and select
appropriate technical solutions including choice of a database management
system as well as the development of logical data models. Procedures and
techniques may include logical data modeling, entity relationship
diagramming, and database normalization. Design considerations should
identify needs for advanced database functionalities such as replication,
standby databases, clustering, partitioning, security features (encryption
or otherwise), and data warehousing functionalities.
*Regards,*
*Upendra Nath*
*(Deputy Resource Manager)*Ramy Infotech
----Consulting redefined
5201 Great America Parkway Suite 320, Santa Clara CA 95054
Phone : *408-317-9256 Ext-311*
Fax : 408-273-6834
Email : *[email protected]* <[email protected]>
URL : www.ramyinfotech.com
YahooID: *upendra.recruiter*
GTalk ID: *upendra.ramy*
--
You received this message because you are subscribed to the Google Groups
"Oracle-Projects" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/oracle-projects.
For more options, visit https://groups.google.com/d/optout.
