Precision Technologies Corp Hiring for Training and Placement on SQL with AZURE Developer at Monmouth Junction, NJ Full Time

Technology: SQL with AZURE Developer

Senior Azure/On Prem MS SQL Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; installation and configuration of SSRS; Support release/code deployment activities (SSIS Packages, SSRS reports, SQL objects etc)

Essential Functions
Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary

• Install/Configure/Setup/Administer and Maintain production and non-production environments
• Setup High-Availability and Disaster Recovery
• Plan and test high availability and disaster recovery
• Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets
• Resolve database integrity, performance, blocking, connectivity, and replication issues.
• Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.
• Perform and manage Database backup/recovery/restore and capacity monitoring
• Synapse workload management and optimization
• Setup SQL agent jobs, elastic jobs and runbook automation
• Identify and setup alerts and logging in Azure
• Maintain databases – Statistics, Indexes, fragmentation
• Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)
• Implement operational automation using scripts.
• Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
• Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
• Deploy and configure SSIS packages and SSRS Reports. Troubleshoot issues with SSRS and SSIS.
• Design and create databases to support development initiatives
• Synapse workload management and optimization
• Support release/code deployment activities
• Provide 24×7 support as necessary

Thank you,

Priya Kinthada

732-792-4531

[email protected]

Job Type: Contract

Salary: $35.00 – $50.00 per hour

Schedule:

• 8 hour shift

Work Location: One location

Speak with the employer
+91 (732) 792-4531