Job Details

ID #40812410
State Washington
City Seattle-tacoma
Full-time
Salary USD TBD TBD
Source IBM
Showed 2022-05-13
Date 2022-05-13
Deadline 2022-07-12
Category Et cetera
Create resume

Database Architect

Washington, Seattle-tacoma, 98101 Seattle-tacoma USA

Vacancy expired!

IntroductionAs an IBM Application Architect, you directly help clients transform their business and solve complex problems. You will define the scope and vision for projects that deliver customized solutions using your knowledge of IBM platforms. You are a technical leader, serving as a liaison among business partners, technical resources, and project stakeholders.Your Role and ResponsibilitiesCreate and manage IAM role users/roles/groups.

Create and managed Oracle, SQL server, Aurora RDS services in AWS.

Migrated multiple databases from on premise to AWS cloud using Amazon DMS service with minimal down time.

Design the target database architecture with the information that was provided by current environment with growth in focus.

Performed 10's of migration from on premise to cloud environment. Including Oracle to PostgresQL, Oracle to Oracle, Oracle to MySQL, Oracle to PostgresQL aurora, PostgresQL- PostgresQL.

Leveraged various AWS services like S3, DMS, RDS, EC2, EBS, EFS, SNS, Cloud watch, Cloud Trail, Redshift, DynamoDB and more.

Required Technical and Professional ExpertiseDatabase Architecht with experience in database migration.

Database migration expereince to Cloud Platform.

Database design and capacity planning.

Perform post migrations checks for enhanced performance improvements by using latest version features.

Performed client demos & knowledge sessions on how they can perform database switch- over/fail overs in cloud environment and do PITR (Point in time recovery).

Migrate database from on-premise to cloud. Migrate with zero down time.

Create and maintain multiple databases required for development, testing and production usage.

Build and maintain physical standby & snapshot databases at remote locations.

Performing the capacity planning required to create and maintain the databases. Working closely with

system administration staff to maintain applications or tools on them in addition to the Oracle Databases.

Performing ongoing Database tuning of the instances & ensure maximum uptime of the database

Planning, implementation and maintaining system backup and recovery strategies for all the databases.

Also implement Oracle fail over technology in case of major disaster to database.

Controlling migrations of programs, database changes, reference data changes and menu changes

throughout the development life cycle.

Preferred Technical and Professional ExpertiseAWS migration skills.

Create pg-SQL/PLSQL to script user creation and account management. Deployed database code changes.

Manually run database backup/snapshots during deployments and DB changes. Generate ad-hoc reports as per business requirements.

Perform regular database reorganization for removing row fragmentation using export and import for Oracle and Vacuum for PostgresQL/redshift.

24/7 support of Production, UAT & DEV databases.

AWS services like SNS,RDS,EC2,LAMBDA,DOCUDB,CFT,CLOUD WATCH etc

Created pg-SQL to script user creation and account management. Deployed database code changes.

Manually run database backup/snapshots during deployments and DB changes. Generate ad-hoc reports as per business requirements.

About Business UnitIBM Consulting is IBM's consulting and global professional services business, with market leading capabilities in business and technology transformation. With deep expertise in many industries, we offer strategy, experience, technology, and operations services to many of the most innovative and valuable companies in the world. Our people are focused on accelerating our clients' businesses through the power of collaboration. We believe in the power of technology responsibly used to help people, partners and the planet.This job requires you to be fully COVID-19 vaccinated prior to your start date, where legally permissible. Proof of vaccination status will be required. If you are unable to be vaccinated due to medical, pregnancy or religious reasons, we offer accommodations in accordance with applicable law.Your Life @ IBMAre you craving to learn more? Prepared to solve some of the world's most unique challenges? And ready to shape the future for millions of people? If so, then it's time to join us, express your individuality, unleash your curiosity and discover new possibilities.Every IBMer, and potential ones like yourself, has a voice, carves their own path, and uses their expertise to help co-create and add to our story. Together, we have the power to make meaningful change - to alter the fabric of our clients, of society and IBM itself, to create a truly positive impact and make the world work better for everyone.It's time to define your career.About IBMIBM's greatest invention is the IBMer. We believe that through the application of intelligence, reason and science, we can improve business, society and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we're also one of the biggest technology and consulting employers, with many of the Fortune 50 companies relying on the IBM Cloud to run their business. At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it's time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.Location StatementIBM offers a wide range of resources for eligible IBMers to thrive both inside and outside of work. In addition to a competitive benefits program consisting of medical and life insurance, retirement plans, and time off, eligible employees may also have access to:12 weeks of paid parental bonding leave. Family care options are also available to support eligible employees during COVID-19.World-class training and educational resources on our personalized, AI-driven learning platform. IBM's learning culture supports your restless attitude to grow your skills and build the depth and scale of knowledge needed to achieve your career goals.Well-being programs to support mental and physical health.Financial programs that empower you to plan, save, and manage your money (including expert financial counseling, 401(k), IBM stock discount, etc.).Select educational reimbursement opportunities.Diverse and inclusive employee resource groups where you can network and connect with IBMers across the globe.Giving and volunteer programs to benefit charitable organizations and local communities.Discounts on retail products, services, and experiences.We consider qualified applicants with criminal histories, consistent with applicable law.Being You @ IBMIBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

Vacancy expired!

Subscribe Report job