Rate Range: $55-$60/hr

Responsibilities
* The role owns, oversees and actively manages all aspects of database systems, data, and data flow in a high volume transactional WMDT platform and supporting systems including WMDT HUB, BPM and ESCHEATMENTS.
* He/she will work closely with all DEV teams and be jointly responsible for implementing and operating complex systems across multiple geographically distributed data centers.
* The DBA will ensure adherence to service operational level agreements in collaboration with application development teams, infrastructure support, project managers, business users, and other cross functional teams to maintain current databases and MDM environment as well as deliver new database implementations.
* The candidate will be responsible for the overall management, project plans, and day to day operations of the distributed database services team.
* Manages all aspects of data propagation and data flow in a high-volume transactional platform and supporting systems including WMDT real time transactions.
* Drive adherence to service operational level agreements.
* Drive operational isolation and zero down time initiatives supporting our online and WMDT platforms
* Defining and build standard procedures and guidelines for all fellow team members and all other Dev teams
* Diagnose and address SQL queries/procedures performance issues using performance monitors tools, custom scripts and various tuning techniques
* Experience in Database Administration and configurations
* Investigate causes of issues and provide recommended solutions as well as implement if necessary.
* Organized with the ability to prioritize tasks accurately and efficiently.

Required Skills
* Minimum 5+ years of experience building distributed enterprise applications on MS SQL Server database platform, with a proven delivery track record.
* Bachelor of Science in Computer Science or equivalent degree.
* Experience in database basic maintenance such as runstats, reorgs, etc.
* Experience in scripting for database deployments
* Expert in tuning all tiers of applications on SQL Server database platform.
* Hands-on experience with Build/Deployment tools and Shell script Strong experience on database backup, restore and data movements export/import/load
* High availability and disaster recovery planning and implementation
* Good knowledge of database concepts with working knowledge on SQL and Stored Procedures.
* Innovative in providing solutions, likes to take on challenges with calculated risk.
* Strive to constantly improve the application development processes and tools
* Provide DBA support on all aspects of databases administration including backup/recovery, deployment, and real time production troubleshooting responsibilities on SQL Server databases.
* Install, configure, monitor, upgrade and maintain database non-production & production environments
* Provide Database deployment support for Development, Test and Production (future) environments
* Diagnose and address database performance issues using performance monitors, custom scripts and various tuning techniques
* Strong experience with SQL tuning
* Interact with Storage and Systems administrators on Linux operating systems issues related to Databases
* Able to write database maintenance and automation scripts
* Configure and maintain Database High availability (HADR)
* Troubleshoot database production problems and database connectivity issues
* Experience working with database federation
* Ability to work well as a team and as an individual with minimal supervision.
* Strong knowledge of Linux/Unix.
* Strong communication and interpersonal skills

Desired skills
* Experience in Wealth Management or a similar Financial environment
* Experience in other data bases SQL HADR, NoSQL, Replications
* Experience in working on Cloud native architecture
* Collaborate with internal teams to produce software design and architecture
* Improve existing software
* Develop documentation throughout the software development life cycle (SDLC)
* Serve as an expert on applications and provide technical support

Powered by JazzHR