| Hiring MSSQL DBA, New York - New York at York, New York, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=126766&uid= From: Swati, SIRI INFO SOLUTIONS INC [email protected] Reply to: [email protected] Hello, Have a nice day...! Greeting from Siri Info Solutions. I am Swati with Siri Info Solutions. We Siri Info Solutions is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. We have an immediate opening for the below position with one of our premium clients Job title: MSSQL DBA Work Location: New York - New York Duration : 6+ Months Minimum years of experience: 8+ years Detailed Job Description: Role/Team Summary : Provide database administration service along with Team Lead. Coordination with Global customers. Following standard team processes and defines new ones with corrections. The individuals will be expected to be fully-functional DBAs who can perform traditional DBA activities independently and guide team members too. Able to provide escalation support whenever required. From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis. Pre-installation Tasks Pre-installation Tasks Installing SQL Server and Patch Mgmt Installing & Maintaining DB Tools Uninstallation Database Upgrade Database Migration Database Patch Installation Physical Database Design and Implementation Database Setup in 32 and 64 architecture Database Clean up / Removal DB Cloning Design Database, RAID configuration & Capacity Planning for Large Databases Setup and implement Cluster Setup in multiple nodes environment Implement High Availability configuration like replication and log shipping Start up and shutdown of Database instances Maintaining Database replication / standby / clusters Job scheduling Verify all Instances and dependent services are running Look for any new error log entries Session / Process Monitoring Query or Transaction monitoring Lock and Deadlock monitoring Activity / Transaction Log monitoring Job monitoring and Purging Job history Replication / Log shipping monitoring Monitor Space usage /growth of Database objects Verify free space in filegroups / databases Monitor transaction log growth and truncate schedule Reorganization of DB to remove fragmentation Update Stats for hot objects Purging of DB logs and trace files Schedule maintenance plans for maintenance like DBCC REINDEX / INDEX DEFRAG Creation and schedule maintenance plans and jobs for update stats , defragmentation, checking database integrity Verify that Server has enough resources for acceptable performance Periodic Report Generation on Database Health Identify bad growth projections Identify space-bound objects Review contention for CPU, memory, network, and disk resources Generating statistics Look for objects that break rules. Ensure that all indexes use an index tablespace Ensure that all tables have unique primary keys. Look for harmful growth rates Examine tuning opportunities. Look for I/O Contention Review fragmentation by investigating row chaining and other areas of fragmentation Database Objects Creation / Review Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc Capture Performance Statistics using performance monitors User / Schema Creation User Management Roles and Privileges Management Look for security policy violations Privileges & Access controls on Database Verify that the database backup was successful Backup execution and monitoring Define Backup policy and retention policy for complete/differential/transaction backup Conduct Backup , restoration drills for backup verification in different scenarios Database Connectivity issues Slow response Operations timed out Dead locks Database Hangs Database incident and error resolution Transaction Log Backup Stuck for Space Database incident and error resolution Vendor Management System Performance Monitoring Maintaining Environment details and change management Windows Scripting for automations of DB related work SSIS and SSRS Implement ITIL processes & Maintain Transition Management Docket Adherence to Change Management Process Presales knowledge / experience is added advantage. Implement ITIL processes & Create Transition Management Dockets Presales knowledge / experience is added advantage. Qualification : As per the Project Requirement Expected Skills / Experience (L1 / L2 / L3) : L3 At least SQL DBA experience, 6+ years required Thorough Knowledge of Windows Operating System, Networks and Active Directory . Knowledge of creating and maintaining standby / replication setup . Strong in SQL fundamentals . Knowledge of using Enterprise Manager and Query Analyzed for basic administration . Knowledge of configuring and setting up maintenance activities for DB . Knowledge of SQL statements tuning and DB Tuning . Knowledge on DB structures (filegroups, Indexes - clustered /non clustered/fillfactor) . Knowledge on Memory structures (configurable parameters) Knowledge of complete /differential / transactional backups and their recovery scenarios . Knowledge on High Availability configuration like replication and log shipping , cluster setup . Knowledge of DTS and bcp and other data load tools across same and different RDBMS Knowledge on database design and storage recommendation and NTFS file systems & capacity planning . Knowledge in making scripts for automations , writing procedures and functions . Knowledge of ITIL processes & Transition Management . Excellent communication Skills Prior experience in a 24x7 environment desired Strong analytical and troubleshooting skills. Provide on-call support as and when required Ability to handle pressure Additional Qualification / Skills : Team Leader MCSE MSSQL Certification is mandatory Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014, 2016, 2017 Versions. Mongodb, Mysql, Postgress, cloud, Azure Personal Attributes : Accepts Responsibility Openness Positive attitude Integrity Commitment Judgement Organized Proactive Please share your Employer details, doc (Visa copy & DL Copy) & share updated resume Current Location Visa status Prefer time to call you Contact No. Skype id LinkedIn URL Education details both Bachelors (university, Stream, Year of passing) & Masters (university, Stream, Year of passing) http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=126766&uid= |
| [email protected] View All |
| 02:23 PM 09-Nov-22 |