Openings for PostgreSQL DBA in Synechron Technologies

Openings for PostgreSQL DBA in Synechron Technologies 

looking for PostgreSQL DBA, resources for the following profiles to start immediately at offshore. The positions are very critical  and we need  the resources by next month, hence would need your help in getting us the right talent at the earliest. 

 Requirement - PostgreSQL DBA

 Position Purpose (Summary):  

The Database Administrator is primarily responsible for the monitoring and maintenance of production database systems in a team environment.  Assists in the design and development of new application databases as well as encourage SQL best practices.

Major Job Accountabilities:

1.Monitor and maintain OLTP and OLAP database systems in a PostgreSQL environment.

2.Ensure database backups and disaster-recovery plans are current.

3.Participate in capacity planning and system monitoring improvements.

4.Develop and improve performance of SQL, functions, and procedures to ensure timely access to data.

5.Develop knowledge of web analytics and click-stream data warehousing techniques. 

6.Develop a working knowledge of Search Engine Optimization (SEO) or Search Engine Marketing (SEM) principles and techniques.

 

Requirements:

Education/Experience:

1.Understanding of database administration tasks and data models, oracle certification .

2.Graduate                                                        

Knowledge/Technical Skills:

1.2+ yrs database administration/development experience. Experience should include installation, tuning, replication, backup, and

  monitoring of database systems.  Expertise in RDBMS such as Oracle, Sybase, SQL Server is acceptable however, PostgreSQL is

  preferred.

2.Comfortable writing and tuning SQL.

3.2+ yrs experience with UNIX/Linux OS and concepts (processes, cron, bash, top).

4.Familiarity with source control using CVS or Subversion.

5.1+ yrs experience creating and reading data models (ERDs).

6.Familiarity with indexing and other optimization techniques.

7.Ability to write in pl/pgsql, pl/perl or pl/sql desired.

8.Thorough understanding of relational models, joins and sub-queries.

Abilities:

1.Ability to be “on-call” 1 week per month.

2.Must possess effective interpersonal and communication skills and ability to work successfully in a team environment.

3.Good organizational and time-management, prioritization skills.

4.Attention to detail and follow-through.

5.High adaptability to rapidly-changing environments.

 

Kindly send in the references to reference@synechron.com