Database Administrator
Database Administrator
Posted on :
12-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
12-02-2025
Job Description
Client: State of New York
Job Title: Database Administrator
Duration: 36 Months
Start Date: ASAP
Location: 505 Clermont Ave 3rd Floor Brooklyn NY 11238 Onsite
Position Type: Contract
Interview Type: Webcam Interview / In Person
Ceipal ID: SNYADM57RP
Requirement ID: #57DSSITSC
Department of Social Service
Job Title: Database Administrator
Duration: 36 Months
Start Date: ASAP
Location: 505 Clermont Ave 3rd Floor Brooklyn NY 11238 Onsite
Position Type: Contract
Interview Type: Webcam Interview / In Person
Ceipal ID: SNYADM57RP
Requirement ID: #57DSSITSC
Department of Social Service
DESCRIPTION:
The Critical Infrastructure support initiative entails the design installation customization testing and implementation of several enhancements to the Agencys Network and Data Center infrastructure environments. These infrastructure related updates are crucial for the efficient maintenance and functioning of the network infrastructure supporting the Network related security controls such as Switches Firewalls IDS IPS Proxy servers etc. as well as its security components in the Data Center Remote sites as well as external entities (OTI NYS etc.)
Tasks & Duties:
- Implement conceptual design to physical database implementation enhance and refine the logical design of the database.
- Monitors and manages SQL Servers and databases on a daytoday basis; develops database designs stored procedures triggers and constraints for new applications in MS SQL Server based on client standards.
- Provides day to day advice to users on data structures and terminology and develops policies and procedures related to the support and maintenance of database applications.
- Monitor databases for optimal performance and acts to mitigate blocking and performance tuning issues.
- Provide guidance to Application Development staff for query stored procedures functions and database design.
- Baseline system performance and monitor for deviation recommending and implementing improvements to slow running queries.
- Document database architecture configuration settings baseline performance metrics and planned and unplanned outages.
- Establishes and implements best practices regarding data definition data quality data security and data integration.
- Performs database administration duties including installation patching backup and recovery management space management schema management startup and shutdown.
Required Skills
- Minimum 4 Years Technical expertise in writing optimal TSQL queries stored procedures User defined functions and views. In depth knowledge and handson experience developing deploying and maintaining complex SSIS packages.
- Minimum 4 Years Through understanding of database maintenance practices including index management backup strategies and disk space requirements. Knowledge of Microsoft systems i.e. WindowsIIS SQL Server 2012 and 2014 Access MS. Experience with backups restores and recovery models.
- Minimum 4 Years Worked in Azure environment like Migration SQL databases from om premise to Azure Cloud. Worked in creating Azure data factories and creating synapse by implementation and configuration. Implemented pipeline creation from Azure synapse to Data verse. Pipeline created between azure synapse to SQL database using data factories.
- Minimum 4 Years Involved in all environments Production and Test and Dev. Having work experience with cluster environment & fail over fail back activity @ the time of patching. Having work experience on Availability groups creations and fail over fail back activity.
- Minimum 4 Years Handled Tempdb/Version store is different situations. Worked on replication Database Mirroring and for high availability solutions.
- Minimum 4 Years Experience in installing managing monitoring and troubleshooting of MS SQL Server 2008R2/2012/2014/2016/2019. SQL Server Security and Object Permissions Management like Maintaining Database authentication modes creation of users configuring permissions and assigning roles to users
- Minimum 4 Years Having experience on Moving system & User defined databases data and log files. Moving the backup from one environment to another environment (Database refresh). Creating Maintenance Plans to perform index defragmentation reindexing and update the index statistics.
V Group Inc. is an IT Services company that supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: CA FL GA MD MI NC NY OH OR PA SC VA and WA CT TN. If you are considering applying for a position with V Group or partnering with us on a position please feel free to contact me with any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website:
LinkedIn:
Facebook:
Twitter:
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
