SQL Server DBA

• Should be able to provide DBA support for distributed servers in a multidatacenter environment.
• Monitor daily activities and performance of complex SQL environment analyzes technical problems recommend adjustments creates and implements approved solutions using established tools and techniques.
• Provide technical assistance to the application development area and coworkers about SQL design and programming.
• Configures SQL services (e.g. security JDBC clusters). Plans installs and coordinates SQL Server releases migrations upgrades and maintenance. Build new environments as needed to support applications.
• Coordinating with the teams of network IIS administrators and storage groups for SQL serverbased configurations.
• Develop technical documents project plans and tasks interact with customers for proposed solutions.
• Provide nonproduction and production support for deploying code and assist in trouble shooting and resolving application issues.
• Support DevOps tools (Ansible Jenkins Nexis Mavin Bitbucket Kony Mobile Nginx etc.)
• Any other tasks assigned by the management team based on project/application needs.
• Provide technical Tier III support develops project plans with project manager or recommends approach through defining tasks.
• Leading meetings relating to design implementation operation and ongoing maintenance of databases systems.
• Designs/plans of cluster nodes hardware selection and recommendations configures/sets up cluster nodes setsup interconnects and configures cluster aware storage; installs cluster and database management system (DBMS) software on all nodes.
• Monitoring load balance and tunes cluster parameters for high performance configuring standby servers.
• Configuring and implements log shipping configures and implements replication etc.
• Provide technical leadership that fosters database innovation and champions automation.
• Support strategic planning for database architecture resource management and capacity planning and growth.
• Ensures best practices in database planning design configuration performance and resilience.
• Evaluate and proposes design and process improvements to achieve performance and cost optimization.
• Identify inefficiencies in current database designs and oversees the implementation of improved solutions.
• Plans and implements capacity and resource expansion to ensure scalability of databases.
• Implements effective risk management controls and owns adherence to all compliance related items (exceptions waivers risks technical compliance and access control)
• Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
• Conducts research and provides recommendations on database products services protocols and standards in support of procurement and development efforts.
• Virtualized Infrastructure running various Unix Linux and AIX operating systems.
• Altering storage structures to meet the evolving needs of the Organization.
• Regularly updating the database security protocols patching.
• Provides leadership and work guidance to less experienced personnel.

sql,dba support,project planning,cluster management,linux,troubleshooting,replication,devops tools,performance tuning,security protocols,risk management,incident resolution,sql server,capacity planning,database management,unix,aix,database,technical documentation