SQL DBA

naIdentifies server hardware, software and configurations necessary for running SQL server in an optimal fashion Performs SQL database installation, configuration, patching and upgrades in a SOX compliant environment Installs, configures and integrates third party applications and tools as needed Develop procedures for automated monitoring and proactive intervention, preventing customer impact Conduct research and make recommendations on database products, services, protocols and standards Configure and optimize Solaris/AIX/Linux servers to support SQL databases Control and monitor user access to databases and ensure regulatory and security compliance Work with application service owners and technical leads to ensure project and service deliverables are met Responsible for providing database expertise to project teams to maximize system availability, efficiency, and security Work with development teams and 3rd party vendors throughout the development life cycle regarding optimal use of database resources and features Responsible for designing, building, testing and deploying database solutions for projects Collaborates with all members of IT to ensure successful application and database implementations Follow release management, change management and quality assurance standards Work with Always On Availability Groups and other SQL Server HA configurations Responsible for SQL Server security and permissions Assumes ownership of database related problems; pursues problem resolution and root cause analysis. Responsible for opening, managing, escalating and resolving SRs with Microsoft Support Assists vendor support services as well as IT team members to quickly resolve problems Monitor and analyze database performance and make changes to optimize performance Responsible for working with the development/support teams to optimize SQL statements Responsible for solving production problems in a timely manner, including off hours and weekend support when necessary Will be the subject matter expert on the supported applications and will provide support to the on call DBA as needed Provide 24x7 support and participate in on-call rotation as needed Responsible for validating the backup strategy and performing on demand backups and restores Develop new backup and recovery processes that leverage new techniques and technology Experience scripting and automating solutions using Perl, Shell, PL/SQL, Python etc Learn and stay current on the features and functionality of Oracle Maintains current knowledge of industry trends and standards Specialized Knowledge/Skills –Must have hands on experience administering SQL Server 2008 and above Must have expert knowledge of Architecture and Concepts Must have experience optimizing database solutions for multi-terabyte databases Must have good knowledge of SQL Server backup and recovery scenarios Must have good knowledge of cross platform database migrations Must have good knowledge of related Tools and Utilities Must have experience optimizing SQL and PL/SQLMust have experience writing scripts using Perl and/or ShellMust have experience in working with Always On Availability GroupsOracle and/or Postgresql experience are nice to havena