Sql Server Ms
Resume:
Cathy Mullican
El Cajon, CA
*********@*****.***
Summary:
Master level programmer with extensive and varied database and backend development experience. Expertise in database migration/enhancement and in maintaining/enhancing legacy code bases. Exceptional skills in requirements clarification and rapid development. Strengths include flexibility, problem solving, and demonstrated ability to analyze, assimilate, and apply new information quickly.
Skills:
Databases: MS SQL Server 2012, MS SQL Server 2019, Azure SQL, Azure Managed Instance, PostgreSQL, MySQL, MongoDB
Languages: Perl 5, bash, PowerShell, XML, Ruby on Rails, Python, JavaScript OS: Windows 10, Unix/Linux/FreeBSD (Solaris, RedHat, Fedora, Centos, Ubuntu, Mac OS X)
Web/Cloud: Azure, Amazon S3, Apache, mod_perl, CGI (legacy), HTML, some CSS Other Tools: DataDog, SSMA, git, svn, CVS, RT, Jira, Bugzilla, maven Employment:
RevShare / Cannella Response Television, Temecula, California, 2015-2024 Database Administrator
Part of a 5-10 person team providing IT support for television advertising time brokerage. Primarily remote.
● Primary responsibility for all database systems -- production, test, and development
● Support, develop, and optimize BI / analytics reporting processes
● Mentor DB developers in other teams
● Researched and implemented tools for monitoring, development, migration and other needs
● Created and supported read-only replicas in MySQL ecosystem to reduce load on primary servers
● Led migration from MySQL 5.7 to SQL Server (Azure Managed Instance) - 200+ functions, 1650+ stored procedures, 570+ tables - resulting in savings of over
$5000/month and significantly decreased maintenance risks
● Supported Azure SQL and on-prem SQL Server databases (SQL Server 2012-2017)
● Developed and enhanced ETL process for reporting server
● Optimized indexing to support query performance proactively and in response to reported issues
● Restructured queries to take advantage of SQL Server features not available in MySQL
Solekai Systems, San Diego, California, 2014-2015
Sr. Software Engineer
Part of a 10-12 person team developing Smart Power Meter Management software used by several large power companies. Partially remote.
● Backend tool developer
● Created and improved build automation scripts
● Created automated monitoring tools
● Improved database performance
● Monitored and troubleshoot customer issues
Mood Media (formerly TruSonic), San Diego, California, 2005-2014 Part of a 3-4 person team supporting a large and growing worldwide user base. Largely remote 2013-2014.
As a DBA:
● Primary DBA and query developer for databases ranging from 350G to 800G, using multiple schemas, triggers, partitioned tables, views, PostgreSQL extensions, and other tools as appropriate
● Created processes and managed transition from a combination of MySQL and an older PostgreSQL system to a unified database system running an up-to-date PostgreSQL
● Tracked data and calculate music royalties
● Created one-off reports and user-triggered report generation tools as needed to support sales, marketing, finance, customers, and other internal and external users
● Built tables, queries, and pl/pgsql functions to support new application functionality
● Developed tools to ingest and process data provided by a variety of external sources
● Added change tracking to many database tables to improve auditing and accountability
● Maintain NANPA records to support dial-up clients As a developer:
● Automated many previously-manual processes
● Provided user interfaces to allow end users to perform routine tasks independently
● Created and maintained tools to support the receiving, fulfillment, and shipping processes, including handling exceptions manually when necessary
● Redesigned and reimplemented the main customer-facing toolsets
● Created backend functionality for new franchise support system
● Created and implemented a new fine-grained permissions model
● Improved functionality of and user experience with web based content and client management tools for both internal and external users As a system administrator:
● 24/7 on-call support for approximately 35 Linux servers:
● 3 public-facing load balanced web servers
● 3 load-balanced content servers supporting deployed devices
● 2 load-balanced RADIUS authentication servers supporting deployed devices
● 2 live database servers plus backup servers
● 1 load balancer, 2 nameservers
● 1 internal ticketing system, 8 content storage servers
● additional backup and internal-use servers
Additional:
● Responded to escalated customer service issues and internal support requests
● Provided technical information for sales and support processes Additional history upon request.
Education:
Harding University, Searcy, Arkansas
BS in Computer Science
Western Governors University
MS in Data Analytics, focus on Data Engineering (in progress)
Contact this candidate