Job Title: Database Administrator - Oracle
Job Location: Boston, Massachusetts
Duration: Contract to Hire
Job Code- 3340-749
Job Description:
Database Administrator with expertise with Oracle solutions, to join our expanding Cloud Services business unit and work with some of the best Cloud Architects and Cloud Engineers in the market. A successful candidate will bring an enthusiasm for professional services delivery work and a willingness to contribute to the overall team. The Database Administrator must be able to interface directly with customers, support project engagements in a hands-on capacity, work collaboratively with other team members and groups within the Cloud Services business unit, and be a trusted advisor and consultant to the customer. The Database Administrator tasks on any task - big or small - to efficiently and effectively get the job done and support Smartronix customer service and delivery missions.
• Hands on experience with following tasks on Oracle and sqlserver databases for OLTP and Datawarehouse applications.
• Configuring operating system and storage to install Oracle (with Real Application Cluster) and Sql Server.
• Installation and configuration of database software (Real Application Cluster for Oracle is a must).
• Upgrade large databases to higher version.
• Develop scripts and processes to migrate data from one platform to another platform.
• Develop scripts and processes to validate data quality for upgrade and migration tasks.
• Fine tune operating system and database for performance and scalability.
• Setup replication features for backup and high availability and redundancy.
• Setup proactive monitoring of system availability, capacity and security.
• Develop backup and recovery procedures and audit tracking procedures.
• Automate routine maintenance, monitoring and deployment procedures.
• Develop security and access management procedure.
• Support apps teams with sqltuning, indexing, partitioning approach to achieve read/write efficiency.
Required Skills
Tools and Technologies
- Oracle 11/12 and above
- Sql Server 2012 and above
- Oracle Data Guard
- Oracle Golden Gate
- Sql Server Agent Service for log shipping
- Databases on AWS/RDS and VMWare/Linux environment
- Automation scripting experience with shell, powershell, etc
Nice to have
- Experience in other databases - postgres, mysql, dynamodb, redshift, aurora, mongodb, hadoop etc.
- Understanding and certification in aws - vpc, ec2, ebs, s3 etc.
- cloud automation scripting like terraform, packer, cloud-formation, python etc.
- Data masking, Data encryption, Data de-identification, Data segmentation etc.
- Experience developing security and compliance process for data environments.
•
Last updated on Aug 28, 2019