SQL/Oracle Database Administrator - Onsite ( No H1B's or E.A.D's)
Vacancy expired!
SQL/Oracle Database Administrator - Onsite Long Island City, NY.6 - 12 Months NO H1B's or E.A.D'sThe person hired for this position will:
- serve as SQL/Oracle Database Administrator in a complex business environment using both SQL server in Azure and Oracle in Solaris/REHL.
- be primarily assigned as a SQL Server DBA working with three other Oracle DBAs.
- have senior level experience in SQL Server database administration, with a working knowledge as Oracle database administrator.
- Support SQL database and Server including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planning.
- Deploy changes in database, proactively monitoring of performance and capacity planning of RDBMS. This includes writing power shell scripts and procedures to automate the process.
- Provide management with recommendations for upgrades and maintenance to ensure the Database Server is running optimally. Perform backup and recovery process, including disaster recovery performance, tuning of database and application.
- Responsible for planning, designing, coordinating and administration of SQL Database Server, including database definition, structure, documentation, standard, and recommending/executing a backup and recovery strategy.
- Work with IT operation team to support various products/applications and assist business users and developers with database-related issues.
- Provide day-to-day production database server administration, perform troubleshooting, and remediate various systems/applications issues.
- Follow and enforce IT Operation policies and procedures.
- Efficiently manage routine DBA requests.
- Must be self-motivated, results-oriented, and able to work on a team.
- Minimum 4 years of experience as Oracle database DBA.
- Minimum 7 years of experience as SQL server database DBA.
- Must have experience and expertise in SQL database server installations, migration, upgrades, capacity planning, performance tuning, backup/recovery, performance[1]oriented design.
- Must be able to lead application development teams in the optimal use of database and transaction management technology through creation and communication of standards and walkthrough of critical application components.
- Microsoft Certified Professional, DBA - MS SQL Certification.
- Solid understanding of RDBMS with in-depth knowledge of Transaction SQL, PL/SQL, and Web Services.
- Experience with Windows Server environments and Microsoft SQL Server database technologies.
- Good experience in configuring and using SQL Server Always On Availability.
- Experience with DevOps, SSRS, SSIS, SSMA and Redgate SQL tools. v Excellent written and communication skills.
- Bachelor's degree in Computer Science, Information Systems or related field.