Job Description
Job Title: Sr Principal database Administrator
Location: Nashua, NH
Pay rate: $75 – 80/hour on W2 basis
Duration: 06 Months
Note: Please send your updated resume if you want to get submitted.
Position Summary:-
BAE Systems is seeking a senior level Database Administrator to install, upgrade, patch, tune, and support Oracle databases supporting evolving applications. Additionally, the candidate must have extensive performance evaluation experience. The ideal candidate should have a minimum of 10 years of experience with managing and supporting Oracle databases. The candidate should be a self-starter, have excellent communication skills and work seamlessly in a team environment as well as independently. The candidate must be willing and able to successfully obtain National Security Clearance.
Skills Required: -
o Extensive experience with Oracle 19c, 18c, 12c, and 11g Architecture and database infrastructure design
o Extensive experience with Oracle Multitenancy including the management and maintenance of Container and Pluggable databases
o Experience automating, scripting and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools
o Ability and experience with the development of processes and procedures to standardize Database installations and configuration
o Extensive experience in the art of performance tuning, utilizing OEM or third party tools to finely tune objects and partitions, advanced stats gathering as well as comprehensive understanding of Oracle 19c and 18c optimizer behavior and Oracle 19c new features, etc.
o Extensive experience with scheduling and utilizing ASH/AWR/ADDM reports and taking corrective actions o Extensive experience with implementation and maintenance of Disaster Recovery environments using Data Guard o Extensive experience with Solaris, Red Hat Linux, and Windows Operating Systems
o Comprehensive understanding of Oracle backup methodologies, their implementation via GUI as well as scripts. Experience with setup and scheduling of RMAN backups as well as successful database restores
o Experience with the development of architectural and functional process diagrams for Oracle database services o Excellent communication, presentation, and customer relationship skills
o Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious
o Proven ability to work creatively and analytically in a problem-solving environment
o “Can-do” attitude, proactive and resourceful
Skills Preferred:
o Oracle OCP or OCM Certification
o Experience in disk array storage solutions – preferably NetApp
o Experience in Backup / Recovery solutions – preferably CommVault
Education Required: -
18+ Years with HS; 14+ Years with AA; 10+ Years with BS or Higher
Kindly answer the below questions if interested for the role:.
1). What is a database?
2). What is DBAs primary responsibility?
3). What view can be used to find list of database users?
4). Which tools did you use to manage databases?
5). What tool is used to apply patches?
6). Name a few index types.
7). What is the use of dbms_metadata API?
8). What is the purpose of external table?
9). What view would you use to see the list of users connected to the database?
10). How much disk space do you typically allocate to install Oracle software?
11). Name a few constraint types on a table.
12). Name a few memory related parameters.
13). What is the purpose of dbms_stats API?
14). Does a DBA really need to know development?