Jobs Tagged: Assist
2 total jobs tagged

Cambridge Associates: Database Administrator

May be expected to act as first contact in a rotating, on-call schedule for database support.Develop alerts, reports and automated processes for failed jobs.Collect and analyze database and system performance measurements over time.Optimize procedures, indexes and table schemas according to trending data.Enforce security measures and policies by minimizing scope of exposure to logins, applying security patches and performing necessary security audits.Review design and deployment of any data objects from development environment to production.Troubleshoot database and hardware-related problems.Monitor SQL Server activity, performance, error logs, event logs, space usage and security on a daily basis.Manage and execute daily operational jobs including backups, index/statistics updatesMonitor and maintain transactional replication and Always on configurations.Preferred Qualifications:Bachelor’s Degree – a degree in a computer science, engineering, mathematics, or science preferred5+ years related professional experienceRelevant technical certificationsAdvanced knowledge of T-SQL development, SSIS, SQL internalsExperience supporting an environment with significant product and software developmentAbility to proactively identify, troubleshoot and resolve live database systems issues.Knowledge of HA and disaster recovery principles and practices, including planning, testing, backup/restoreKnowledge of Windows Server architecture and patchingUnderstanding and experience with transactional replication, clustering and other HA solutionsExperience installing/upgrading/patching/configuring SQL 2008/2012/2014Knowledge of PowerShellKnowledge and/or experience with 3rd party backup and performance monitoring tools a plusKnowledge of SSRS and SharePoint integration a plusExperience with SAN/Storage technologies, virtual environments and OLAP/SSAS data warehouse solutions a plusExposure to new database technologies such as NoSQL, in-memory databases, graph databases and/or data grids a plusKnowledge of source control and release management systems a plusCandidates must be eligible to work in the US without sponsorshipKey Competencies:Critical thinking and problem solving skillsDecision-makingTeam workStress toleranceAbility to raise difficult issues in a constructive wayApply:…

Source: Authentic Jobs