Sr. Database Developer

22 Jun 2024

Vacancy expired!

Level 4Description:Sr. Database Developer/AdminRoleName: Sr. Database Developer/AdminPositionTitle: Sr ConsultantLocation: Alpharetta, GA, USAAbout our Company:Since our founding in 1935, we have been committed to serving local and global communities by being a market leader in Investment Banking, Securities, Investment Management and Wealth Management services. Our belief that capital can work to benefit all of society inspires us to put our clients first, lead with exceptional ideas, hold our business to high ethical standards, and give back to communities around the world through philanthropy and public works. We have a smart casual dress code and operate under a philosophy that balances work with your personal life. Our peoples talent, passion, and expertise is the fuel on which our organization runs, therefore, our people are our greatest asset. Diversity and inclusiveness is a critical component for our success and it is our priority to continue building a firm that values the unique background and identity of every one of our employees, thus enabling our people to bring their full, and best selves to work each day. Teamwork is the essence of our approach, and so are the values of integrity, excellence, and enabling our people to achieve at the highest levels. We invite you to learn more about our commitment to diversity and serving our community.MS Wealth Management (MSWM) Technology

Our Wealth Management (MSWM) Technology is the global technology department responsible for the design, development, delivery and support of the technical solutions behind the products and services used by the our Wealth Management (MSWM) business. The department is comprised of 10 organizations: Sales, Banking & Corporate-Client Technology, Investment Products & Markets Technology, Client Reporting, Core Processing, Private and International Wealth Management Technology, Technology Integration Office, Enterprise Infrastructure & Production Management, Capital Markets Application & Data Services, Deployment Planning & Release Management, and the Chief Operating Office.

Department Profile:Wealth Managements Core Platform Services group provides horizontal services to all Wealth management Development Teams. Our mission is to provide stable and scalable infrastructure and technology solutions for entire Wealth Management. We serve as a centralized interface through which Wealth Management teams can obtain infrastructure solutions and project support by working closely with application owners throughout the SDLC process to ensure that established products/services are leveraged, and new requirements are fulfilled.

Position Description:This position is for a Sr. Database Developer/Admin to work with our cross-functional team and join our WMDT Platform Support/Engineering team at our Bengaluru offices. We are looking for colleagues with strong sense of ownership and ability to drive solutions. The role is primarily responsible to automate the existing process and bring new ideas and innovation. The candidate is expected to code, conduct code reviews, and test software as needed, along with participating in application architecture and design and other phases of the SDLC. The ideal candidate will be a self-motivated team player committed to delivering on time and should be able to work with without or minimal supervision.

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 guide lines 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 10+ years of experience building distributed enterprise applications on IBM DB2 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 DB2 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 DB2 UDB 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

  • ID: #43471463
  • State: Georgia Alpharetta 30004 Alpharetta USA
  • City: Alpharetta
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-06-22
  • Deadline: 2022-08-20
  • Category: Software/QA/DBA/etc