Senior Database Administrator - Horsham, PA (outside Philadelphia), Permanent
Mark Perri <[email protected]> Fri, 27 Jul 2018 13:12:38 +0000
| Newsgroups | gmane.comp.db.postgresql.jobs |
|---|---|
| Message-ID | <BN7PR07MB4209C9B45DBCCEC665E8F2C1D02A0@BN7PR07MB4209.namprd07.prod.outlook.com> |
--_000_BN7PR07MB4209C9B45DBCCEC665E8F2C1D02A0BN7PR07MB4209namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
TherapyNotes is seeking an experienced database professional to join our gr=
owing team. The right candidate will have extensive experience administerin=
g PostgreSQL databases, both on-premise and in the cloud. They will be comf=
ortable working in a highly collaborative, DevOps culture working alongside=
members of our technology organization to administer PostgreSQL databases =
in our development, test, and production environments.
To apply, please visit https://therapynotes.workable.com/
Responsibilities
* Responsible for designing, implementing, and managing critical databa=
se systems (PostgreSQL) which support a growing 24x7 SAAS platform.
* Ensures the database design and operations support the availability, =
scalability, and recoverability needs of the business.
* Performs tuning and capacity management to ensure the database meets =
the performance needs of the business.
* Guides and provides direction to developers and engineers on database=
development, design principles, query optimization, and index management i=
n a fully automated deployment pipeline.
* Provide support for development and testing including test data setup=
, automated testing scenarios, and dev/test environment data refreshes.
* Research and evaluate emerging database technologies and trends to en=
hance the use of data and databases within the organization.
* Provides leadership for all policies and procedures that govern data =
operations, security, management and usage.
* Accountable for complying with HIPAA security policies within the dat=
abase platform.
* Provides on-call coverage for production support and manage.
Requirements
* 7+ years' experience with relational database administration
* 3+ years' experience administering highly-available PostgreSQL databa=
ses
* Familiarity with RDBMS principles, database design and normalization.
* Expert experience in PostgreSQL database architecture, concepts, feat=
ures, and high-availability technologies.
* Expert experience in query optimization, indexing knowledge, modeling=
basics, materialized views and partitioning.
* Expert experience with PL/PgSQL, triggers, and stored procedure devel=
opment and optimization in PostgreSQL.
* Proficiency with operating PostgreSQL in a Linux environment.
* Experience with .NET clients using npSQL a plus.
* Experience with RDBMS in the cloud a plus.
* Experience with Oracle and MS SQL Server a plus.
* Understanding of agile software and DevOps principles a plus.
Benefits and Perks
TherapyNotes offers careers that provide you with the freedom to do amazing=
work, interact with great people, and offer fantastic learning and growth =
opportunities. Our team empowers and challenges each other to learn and sol=
ve complex problems. We build and manage web applications with a strong emp=
hasis in healthcare. If you are looking to join a supportive team, use your=
leadership experience, and build great products, please submit your applic=
ation.
* Competitive salary
* Comp time and flexible work hours
* Retirement plan with company matching
* Full health, life, disability, and dental insurance
* Personal development/training budget
* Open, collaborative work environment
* Company provided refreshments
TherapyNotes is an Equal Employment Opportunity Employer. All candidates wh=
om have been given a conditional offer of employment with TherapyNotes.com =
must also undergo a criminal background check.
--_000_BN7PR07MB4209C9B45DBCCEC665E8F2C1D02A0BN7PR07MB4209namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:546527688;
mso-list-type:hybrid;
mso-list-template-ids:719881648 67698689 67698691 67698693 67698689 676986=
91 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:1052460919;
mso-list-type:hybrid;
mso-list-template-ids:-1059308074 67698689 67698691 67698693 67698689 6769=
8691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2
{mso-list-id:1934514308;
mso-list-type:hybrid;
mso-list-template-ids:779004430 67698689 67698691 67698693 67698689 676986=
91 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">TherapyNotes is seeking an experienced database prof=
essional to join our growing team. The right candidate will have extensive =
experience administering PostgreSQL databases, both on-premise and in the c=
loud. They will be comfortable working
in a highly collaborative, DevOps culture working alongside members of our=
technology organization to administer PostgreSQL databases in our developm=
ent, test, and production environments.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">To apply, please visit <a href=3D"https://therapynot=
es.workable.com/">
https://therapynotes.workable.com/</a> <o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><b>Responsibilities<o:p></o:p></b></p>
<ul style=3D"margin-top:0in" type=3D"disc">
<li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l1 level1 =
lfo3">Responsible for designing, implementing, and managing critical databa=
se systems (PostgreSQL) which support a growing 24x7 SAAS platform.<o:p></o=
:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l1=
level1 lfo3">Ensures the database design and operations support the availa=
bility, scalability, and recoverability needs of the business.<o:p></o:p></=
li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l1 leve=
l1 lfo3">Performs tuning and capacity management to ensure the database mee=
ts the performance needs of the business.<o:p></o:p></li><li class=3D"MsoLi=
stParagraph" style=3D"margin-left:0in;mso-list:l1 level1 lfo3">Guides and p=
rovides direction to developers and engineers on database development, desi=
gn principles, query optimization, and index management in a fully automate=
d deployment pipeline.<o:p></o:p></li><li class=3D"MsoListParagraph" style=
=3D"margin-left:0in;mso-list:l1 level1 lfo3">Provide support for developmen=
t and testing including test data setup, automated testing scenarios, and d=
ev/test environment data refreshes.<o:p></o:p></li><li class=3D"MsoListPara=
graph" style=3D"margin-left:0in;mso-list:l1 level1 lfo3">Research and evalu=
ate emerging database technologies and trends to enhance the use of data an=
d databases within the organization.<o:p></o:p></li><li class=3D"MsoListPar=
agraph" style=3D"margin-left:0in;mso-list:l1 level1 lfo3">Provides leadersh=
ip for all policies and procedures that govern data operations, security, m=
anagement and usage.<o:p></o:p></li><li class=3D"MsoListParagraph" style=3D=
"margin-left:0in;mso-list:l1 level1 lfo3">Accountable for complying with HI=
PAA security policies within the database platform.<o:p></o:p></li><li clas=
s=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l1 level1 lfo3">Pr=
ovides on-call coverage for production support and manage.<o:p></o:p></li><=
/ul>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><b>Requirements<o:p></o:p></b></p>
<ul style=3D"margin-top:0in" type=3D"disc">
<li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l0 level1 =
lfo2">7+ years’ experience with relational database administratio=
n<o:p></o:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;ms=
o-list:l0 level1 lfo2">3+ years’ experience administering highly-=
available PostgreSQL databases<o:p></o:p></li><li class=3D"MsoListParagraph=
" style=3D"margin-left:0in;mso-list:l0 level1 lfo2">Familiarity with RDBMS =
principles, database design and normalization.<o:p></o:p></li><li class=3D"=
MsoListParagraph" style=3D"margin-left:0in;mso-list:l0 level1 lfo2">Expert =
experience in PostgreSQL database architecture, concepts, features, and hig=
h-availability technologies.<o:p></o:p></li><li class=3D"MsoListParagraph" =
style=3D"margin-left:0in;mso-list:l0 level1 lfo2">Expert experience in quer=
y optimization, indexing knowledge, modeling basics, materialized views and=
partitioning.<o:p></o:p></li><li class=3D"MsoListParagraph" style=3D"margi=
n-left:0in;mso-list:l0 level1 lfo2">Expert experience with PL/PgSQL, trigge=
rs, and stored procedure development and optimization in PostgreSQL.<o:p></=
o:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l=
0 level1 lfo2">Proficiency with operating PostgreSQL in a Linux environment=
.<o:p></o:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;ms=
o-list:l0 level1 lfo2">Experience with .NET clients using npSQL a plus.<o:p=
></o:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-lis=
t:l0 level1 lfo2">Experience with RDBMS in the cloud a plus.<o:p></o:p></li=
><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l0 level1=
lfo2">Experience with Oracle and MS SQL Server a plus.<o:p></o:p></li><li =
class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l0 level1 lfo2=
">Understanding of agile software and DevOps principles a plus.<o:p></o:p><=
/li></ul>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><b>Benefits and Perks<o:p></o:p></b></p>
<p class=3D"MsoNormal">TherapyNotes offers careers that provide you with th=
e freedom to do amazing work, interact with great people, and offer fantast=
ic learning and growth opportunities. Our team empowers and challenges each=
other to learn and solve complex
problems. We build and manage web applications with a strong emphasis in h=
ealthcare. If you are looking to join a supportive team, use your leadershi=
p experience, and build great products, please submit your application.<o:p=
></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<ul style=3D"margin-top:0in" type=3D"disc">
<li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l2 level1 =
lfo1">Competitive salary<o:p></o:p></li><li class=3D"MsoListParagraph" styl=
e=3D"margin-left:0in;mso-list:l2 level1 lfo1">Comp time and flexible work h=
ours<o:p></o:p></li><li class=3D"MsoListParagraph" style=3D"margin-left:0in=
;mso-list:l2 level1 lfo1">Retirement plan with company matching<o:p></o:p><=
/li><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l2 lev=
el1 lfo1">Full health, life, disability, and dental insurance<o:p></o:p></l=
i><li class=3D"MsoListParagraph" style=3D"margin-left:0in;mso-list:l2 level=
1 lfo1">Personal development/training budget<o:p></o:p></li><li class=3D"Ms=
oListParagraph" style=3D"margin-left:0in;mso-list:l2 level1 lfo1">Open, col=
laborative work environment<o:p></o:p></li><li class=3D"MsoListParagraph" s=
tyle=3D"margin-left:0in;mso-list:l2 level1 lfo1">Company provided refreshme=
nts<o:p></o:p></li></ul>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">TherapyNotes is an Equal Employment Opportunity Empl=
oyer. All candidates whom have been given a conditional offer of employment=
with TherapyNotes.com must also undergo a criminal background check.<o:p><=
/o:p></p>
</div>
</body>
</html>
--_000_BN7PR07MB4209C9B45DBCCEC665E8F2C1D02A0BN7PR07MB4209namp_--