PostgreSQL Database Architect



BCforward is currently seeking a highly motivated PostgreSQL DB Architect role in Plano, TX


Position Title: PostgreSQL DB Architect



Location: Plano, TX


Anticipated Start Date: Tentative start Date 10/16/2024

Please note this is the target date and is subject to change. BCforward will send official notice ahead of a confirmed start date.

Expected Duration: 06+ Months with a Strong possibility of Extension


Job Type: Contract: 40hr/ week


Pay Range: $55.71/hr. to $61.29/hr. on W2

Please note that actual compensation may vary within this range due to factors such as location, experience, and job responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem, etc.).

Job Description:



Technical Requirements:
* PostgreSQL database Administration, in-depth hands-on experience is a must.
* Good experience PostgreSQL DBA activities.
* Strong experience in PostgreSQL Performance Tuning and Optimization
* Hands on experience backup strategy and high availability in production databases
* Skilled at optimizing large, complicated SQL statements in PostgreSQL.
* Strong experience in performance tuning on SQL queries.
* Experience in table partitions
* Strong experience in JOINS and Sub Queries
* Skilled at optimizing large, complicated SQL statements and stored procedures, functions.
* Strong with common database procedures such as upgrade, patch, recovery, migration, High
Availability
* Ensure performance, security, and availability of databases.
* Need to have strong experience in PostgreSQL HIGH Availability Solutions.
* Design and develop PostgreSQL systems including statements, data modelling, tables, views, and indexes.
* Knowledge of best practices when dealing with relational databases PostgreSQL.
* Setting up the configuration parameters in PostgreSQL Database.

Qualifications:
* 10+ years of experience in PostgreSQL Administration
* Extensive experience in PostgreSQL SQL and PLSQL (PG/PLSQL) Coding.
* Experience in conversion of ETL mappings from Oracle to Postgres.
* Good analytical and problem-solving skills for design, creation and testing of programs.
* Good communication skills to interact with team members, support personnel, and provide technical guidance and expertise to customers and management.
* Good interpersonal skills to interact with customers and team members.
* Ability to work in a self-directed work environment.
* Ability to work in a team environment.



Keywords:


PostgreSQL DBA, PL/SQL, ETL Mappings

Who to Contact: Manoj krishna

About BCforward:
Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing unique solutions supporting value capture and digital product delivery needs for organizations around the world. Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000 consultants support more than 225 clients globally.


BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled


BCforward to become a market leader and best in class place to work.


BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.
To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our Privacy Notice and CCPA Addendum. As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.
This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.


Interested candidates please send resume in Word format Please reference job code 229793 when responding to this ad.


Get job alerts by email.Sign up now!Join Our Talent Network!



Job Snapshot




Employee Type

Contractor



Location

Plano, TX (Onsite)



Job Type

Information Technology



Experience

Not Specified



Date Posted

09/30/2024