-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
226 lines (226 loc) · 9.17 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" lang="English" xml:lang="English">
<head>
<meta charset="utf-8" />
<meta name="generator" content="pandoc" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=yes" />
<meta name="author" content="Ajay Kumar Dwivedi" />
<meta name="description" content="SQLServer/PostgreSQL Database Design, Optimization & Automation" />
<title>Ajay Kumar Dwivedi</title>
<style>
code{white-space: pre-wrap;}
span.smallcaps{font-variant: small-caps;}
div.columns{display: flex; gap: min(4vw, 1.5em);}
div.column{flex: auto; overflow-x: auto;}
div.hanging-indent{margin-left: 1.5em; text-indent: -1.5em;}
/* The extra [class] is a hack that increases specificity enough to
override a similar rule in reveal.js */
ul.task-list[class]{list-style: none;}
ul.task-list li input[type="checkbox"] {
font-size: inherit;
width: 0.8em;
margin: 0 0.8em 0.2em -1.6em;
vertical-align: middle;
}
.display.math{display: block; text-align: center; margin: 0.5rem auto;}
</style>
<link rel="stylesheet" href="css/design-light.css" />
<link rel="icon" type="image/png" href="img/resume.png" />
</head>
<body>
<p><img src="img/Ajay-Kumar-Dwivedi.jpeg" alt="Description" width="200px"></p>
<h1 id="ajay-kumar-dwivedi">🚀 <strong>Ajay Kumar Dwivedi</strong></h1>
<p><strong>SQL Server / PostgreSQL Database Administrator &
Developer</strong><br />
<strong>Automation | Performance Tuning | Query Optimization |
Monitoring</strong></p>
<p>🌐 <a href="https://ajaydwivedi.com">ajaydwivedi.com</a> | 💻 <a
href="https://imajaydwivedi.github.io/">GitHub</a> | 🔗 <a
href="https://www.linkedin.com/in/imajaydwivedi">LinkedIn</a><br />
✉️ <a
href="mailto:ajay.dwivedi2007@gmail.com">ajay.dwivedi2007@gmail.com</a>
| 📞 <a href="tel:+917032312749">+91 7032312749</a></p>
<hr />
<h2 id="professional-summary">📊 <strong>Professional
Summary</strong></h2>
<p>✅ <strong>14 years of expertise</strong> in SQL Server and
PostgreSQL databases.<br />
✅ Specialist in <strong>Database Design</strong>, <strong>Performance
Optimization</strong>, and <strong>Automation</strong>.<br />
✅ Skilled in <strong>PowerShell</strong>, <strong>Python</strong>, and
<strong>Grafana</strong> for monitoring and alerting.<br />
✅ Ensures <strong>high availability</strong>, <strong>data
integrity</strong>, and <strong>optimized database systems</strong>.</p>
<hr />
<h2 id="employment-history">💼 <strong>Employment History</strong></h2>
<h3 id="senior-site-reliability-engineer-angelone-feb-2022-present">🎯
<strong>Senior Site Reliability Engineer</strong> |
<strong>AngelOne</strong> <em>(Feb 2022 – Present)</em></h3>
<ul>
<li>📊 <strong>280+ SQL Servers Baselined</strong> using self built <a
href="https://ajaydwivedi.com/demo/sqlmonitor">SQLMonitor</a>.<br />
</li>
<li>🚨 Developed <strong>Alert Engine</strong> tool via
<strong>Flask</strong>, <strong>Grafana</strong> and
<strong>Python</strong>.<br />
</li>
<li>⚙️ Optimized SQL Server performance with <strong>D.E.A.T.H
Methodology</strong> <em>(IO latency: 350ms → <9ms)</em>.<br />
</li>
<li>🔒 Automated <strong>Transparent Data Encryption (TDE)</strong> for
<strong>280+ servers</strong>.<br />
</li>
<li>🛠️ Tuned <strong>PostgreSQL queries</strong> for efficient parallel
plans and indexing.</li>
<li>🛠️ Fixed <strong>MSSQL query problems</strong> like Ascending Key
issue, Kitchen Sink design, uneven threading, distributed query plans,
MSTVFs, etc.</li>
<li>⚙️ Automated bi-directional <strong>Transactional
Replication</strong> for DR setup using PowerShell.</li>
</ul>
<h3 id="database-reliability-engineer-arcesium-may-2020-feb-2022">🎯
<strong>Database Reliability Engineer</strong> |
<strong>Arcesium</strong> <em>(May 2020 – Feb 2022)</em></h3>
<ul>
<li>🛡️ Designed <strong>AlwaysOn Readiness Solutions</strong> using
PowerShell & Grafana.<br />
</li>
<li>🚚 Designed <strong>PowerShell module</strong> to move <strong>38
TB</strong> AG databases.</li>
<li>🚀 Automated/Upgraded <strong>30 SQL Instances</strong>, having
<strong>Replication on top of AG replicas formed of SqlClusters</strong>
in <strong>12 hours</strong>.</li>
<li>🛠️ Fixed <strong>High CPU/Query Regression</strong> issues.</li>
<li>🛠️ Automated <strong>Script Out</strong> of entire SQLServer
Instance</li>
</ul>
<h3 id="senior-sql-server-dba-tivo-feb-2018-may-2020">🎯 <strong>Senior
SQL Server DBA</strong> | <strong>TiVo</strong> <em>(Feb 2018 – May
2020)</em></h3>
<ul>
<li>🛠️ Built <strong>DBA Inventory</strong> using <strong>Python,
Django, and PowerShell</strong>.<br />
</li>
<li>⚙️ Automated SQLServer <strong>deployment</strong> using
<strong>PowerShell</strong>.</li>
</ul>
<h3 id="senior-sql-server-dba-united-health-group-oct-2016-feb-2018">🎯
<strong>Senior SQL Server DBA</strong> | <strong>United Health
Group</strong> <em>(Oct 2016 – Feb 2018)</em></h3>
<ul>
<li>💰 Saved <strong>$1.0 million/year</strong> via <a
href="https://github.com/imajaydwivedi/Space-Capacity-Automation"><strong>DB
Space Capacity Automation</strong></a>.</li>
<li>🛡️ Managed <strong>VLDBs</strong> effectively under load.</li>
</ul>
<h3 id="senior-sql-server-developer-ericsson-jun-2015-oct-2016">🎯
<strong>Senior SQL Server Developer</strong> | <strong>Ericsson</strong>
<em>(Jun 2015 – Oct 2016)</em></h3>
<ul>
<li>🚀 <strong>3x Performance Improvement</strong> via advanced query
optimization like Recursive CTE and Table Partitioning.<br />
</li>
<li>🧠 Mentored team on <strong>SQL Best Practices</strong>.</li>
</ul>
<hr />
<h2 id="education-certifications">🎓 <strong>Education &
Certifications</strong></h2>
<ul>
<li>🎓 <strong>Bachelor of Engineering</strong> – <em>RGPV University,
Bhopal (2006–2010)</em><br />
</li>
<li>📚 <strong>SQLSkills Blackbelt Bundle</strong> – <em>SQLSkills.com
(2022 – 2024)</em><br />
</li>
<li>📚 <strong>Fundamentals & Mastering Bundle</strong> –
<em>BrentOzar Unlimited (2021–2022)</em></li>
</ul>
<hr />
<h2 id="key-projects">🛠️ <strong>Key Projects</strong></h2>
<p>✅ <strong><a
href="https://ajaydwivedi.com/powershell/how-to-handle-passwords-in-powershell-automation/">CredentialManager</a></strong>
– Safely use with credentails in automations.<br />
✅ <strong><a
href="https://github.com/imajaydwivedi/SqlMonitor">SQLMonitor</a></strong>
– Baseline and monitor SQL Server.<br />
✅ <strong><a
href="https://ajaydwivedi.com/sqlmonitor/setup-sqlserver-alerts-with-open-source-sqlmonitor/">SQLMonitor-AlertEngine</a></strong>
– Advanced alerting system.<br />
✅ <strong><a
href="https://github.com/imajaydwivedi/SQLDBA-SSMS-Solution">SQLDBA-SSMS-Solution</a></strong>
– Daily DBA task scripts.<br />
✅ <strong><a
href="https://github.com/imajaydwivedi/HadrSync">HadrSync</a></strong> –
Replica synchronization.<br />
✅ <strong><a
href="https://github.com/imajaydwivedi/Space-Capacity-Automation">Space-Capacity-Automation</a></strong>
– Disk space management.<br />
✅ <strong><a
href="https://github.com/imajaydwivedi/SQLDBATools">SQLDBATools</a></strong>
– PowerShell module to help with DBA activities.</p>
<hr />
<h2 id="skills">💡 <strong>Skills</strong></h2>
<table>
<thead>
<tr class="header">
<th><strong>Skill Area</strong></th>
<th><strong>Proficiency</strong></th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td><strong>Database Systems</strong></td>
<td>SQL Server, PostgreSQL</td>
</tr>
<tr class="even">
<td><strong>Automation Tools</strong></td>
<td>PowerShell, Python, Bash</td>
</tr>
<tr class="odd">
<td><strong>Monitoring Tools</strong></td>
<td>Grafana, Prometheus</td>
</tr>
<tr class="even">
<td><strong>DevOps Tools</strong></td>
<td>Docker, Ansible, Git</td>
</tr>
<tr class="odd">
<td><strong>OS Expertise</strong></td>
<td>Ubuntu, Windows</td>
</tr>
<tr class="even">
<td><strong>Web Frameworks</strong></td>
<td>Flask, Django</td>
</tr>
</tbody>
</table>
<hr />
<h2 id="awards-achievements">🏆 <strong>Awards &
Achievements</strong></h2>
<p>🏅 <strong>Multiple Automation Awards</strong> for innovative
automation scripts.<br />
📝 <strong>Technical Blog:</strong> <a
href="https://ajaydwivedi.com">ajaydwivedi.com</a><br />
🎥 <strong>Live YouTube Tutorials:</strong> <a
href="https://ajaydwivedi.com/go/youtube">YouTube Sessions</a><br />
👨🏫 <strong>Instructor Experience:</strong> Taught <strong>C/C++
(2008–2010)</strong></p>
<hr />
<h2 id="final-note">📣 <strong>Final Note</strong></h2>
<p>I’m passionate about <strong>designing efficient database
systems</strong> and <strong>solving complex performance
challenges</strong>. Ready to bring expertise, innovation, and
dedication to your organization.</p>
<p>✨ <strong>Let’s connect and discuss how I can add value to your
team!</strong></p>
<p><br></p>
<h6 id="download-the-cv-in-pdf-format-.-last-update-jan-2025."><a
href="Ajay_Kumar_Dwivedi.pdf">Download the CV in PDF format</a> . Last
update Jan 2025.</h6>
<h6 id="this-cv-uses-my-markdown-resume.">This CV uses my <a
href="https://github.com/imajaydwivedi/imajaydwivedi.github.io/blob/main/README.md">Markdown
Resume.</a></h6>
<h6 id="light-dark"><a href="./">Light 🌕</a> <a href="dark.html">Dark
🌑</a></h6>
</body>
</html>