Title: Database Administrator
Duration: Brooklyn, NY
Location: NYC
Tasks & Duties
- Create and maintain Oracle Databases. Report and make recommendations on database improvements. Ensure current database security standards are maintained
- Responsible for SQL Server Database development and support.
- Creates, maintains, and updates SQL Server Infrastructure and Standards DBA documentation.
- Works with vendors to architect, design and configure large, complex databases with replication and high availability on the most current MSSQL versions.
- Develops and maintains application, data, and execution architectures.
- Provides input into overall development/implementation plan and documents database builds and changes, performs SQL designs, table designs, and stored procedures work.
- Manages large tables, maintains schemas, and develops queries and utilities to assist users.
- Installs upgrades and patches to existing databases.
- Creates databases, tuning, cloning, copying, and data refreshes.
- Performs system analysis and identifies solutions to technical problems
- Identifies bottlenecks and performs database tuning.
- Create and maintains all databases required for development, QA, Staging and production usage
- Install new versions of the SQL Server and its tools.
- Performs the capacity planning required to create and maintain the databases and carry out tuning of database instances.
- Work closely with system administration staff because Computers often have applications or tools on them in addition to SQL Server databases
- Experience with Windows Server environments
- Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
- Extensive experience with database replication (Qlik/Attunity)
- Experience with cloud services (AWS, Microsoft Azure)
Required Skills
· A minimum of 6 years of experience with the following skill sets:
· SQL 2008/2008R2/2012/2014/2016/2019/2022 database management and related products
· Microsoft includes PowerShell, Windows Server operating systems.
· Advanced SQL queries and reading query execution plan, developing and performance tuning complex, SSRS and SSIS packages.
· SQL Server Always on High Availability configuration, support, and troubleshooting.
· Performance tuning, Performance monitoring, “Live” and Scheduled replication, Log shipping, Database Mirroring, Database capacity planning, Users and Role creation and monitoring.
Thanks,
Veera | Business Development Manager |
Direct: 1-| Fax: 1- |
Enternet Business Systems Inc | Morganville, NJ 07751|
Email: |
| USA | India |
(Established in 1998)
Celebrating 25 Years of Excellence!
Never miss an opportunity! Create an alert based on the job you applied for.